attach a file to the email during mail merge

[Edward]

Hi everyone,
I use mailmerge in word to create email messages for different recipients
but the problem i have is after I create the merged document it automatically
sends the emails to each recipient I wonder if there is way to send thoses
emails to my drafts folder because I want to attach some files o each email
and then send them manually, It's okay if the soultion needs VBA becasue Im
familiar with VBA .

 

[Graham Mayor]

See the article prepared by fellow MVP Doug Robbins at
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[JP]

Hey Edward, I was working with you in the Outlook ng on your other
problem. You might need to switch your routine to use Outlook
automation -- you can't do this directly with Word mail merge. If you
were to use Outlook to send the email, you could use the .Save
Property, it should save the email to your drafts folder.

But if you follow the code I sent you, you wouldn't need to do this at
all, you could attach the necessary files as part of the macro without
saving them to the drafts folder first.


HTH,
JP