How do I add an attachment & include a message in mail merge email

[RayK]

I want to create an Word mail merge to email and have a message body in the
email and also include a file as an attacment to the email.

Any help would be appreciated.

 

[Doug Robbins - Word MVP]

See the article "Mail Merge to E-mail with Attachments" at

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


--
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

 

[bruce k]

I am also trying to do this. I read the article posted Doug Robbins and it is
too complicated for me. If there is a way to do in word outlook or excel
without additional programming I would be intersted otherwise I will use a
less eficient email message.

 

[Peter Jamieson]

You will have to use VBA, and you have to be using Outlook (or some other
e-mail program that can be automated from VBA), but
a. should the message body be the same for every message, or be generated
from the body text of the Mail Merge Main Document?
b. should the attachment be the same for every message, or should it be
generated from the Mail Merge main document?