Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2008

Tip: Looking for answers? Try searching our database.

How can I email a mail-merged document?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
derektburg - 19 Feb 2008 06:32 GMT
I have an Excel document that contains 5-6 pieces of employee data that will
be merged into a Word form. This will create a 2-page document for each
employee that I would like to email to them. Is there a way that I can merge
this data into one large document but then email specific pages based on the
appropriate employee?
Peter Jamieson - 19 Feb 2008 09:30 GMT
If you can decide which pages you need to send automatically (i.e. on the
basis of the data in the mail merge data source) then you can consider using
INCLUDETEXT fields to include the additional page(s) optionally, then merge
directly to e-mail. e.g. if you have a field called includepage2 which is
"Y" if you want page 2, you might be able to use

{ IF "{ MERGEFIELD includepage2 }" = "Y" "put a page break in here with all
the other stuff you want, including fields" "" }

All the {} need to be the special field braces that you can insert using
ctrl-F9.

If you want to try this approach, I'd start by doing some very simple
feasibility tests on the machine you intend to use for the merge.

Otherwise, you can consider using VBA and a combination of two Doug Robbins
techniques, which you should find here:
http://www.gmayor.com/individual_merge_letters.htm
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I have an Excel document that contains 5-6 pieces of employee data that
>will
[quoted text clipped - 4 lines]
> the
> appropriate employee?
Doug Robbins - Word MVP - 19 Feb 2008 09:50 GMT
See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.

And then to email them out, see the article "Mail Merge to E-mail with
Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have an Excel document that contains 5-6 pieces of employee data that
>will
[quoted text clipped - 4 lines]
> the
> appropriate employee?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.