attach a file to the email during mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Edward - 14 Nov 2007 11:49 GMT

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 .

Signature

Best regards,
Edward

Reply to this Message

Graham Mayor - 14 Nov 2007 12:02 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi everyone,
> I use mailmerge in word to create email messages for different
[quoted text clipped - 3 lines]
> 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 .

Reply to this Message

JP - 14 Nov 2007 15:44 GMT

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

> Hi everyone,
> I use mailmerge in word to create email messages for different recipients
[quoted text clipped - 7 lines]
> Best regards,
> Edward

Reply to this Message