Mail merge email with attatchments

[Michelle Hanan]

I have a macro that is in an excel worksheet. The macro merges data from the
worksheet into word documents and then merges the finished product to the
printer. Right now I am trying to set up a new macro that instead of merging
it to the printer, it merges to email. The catchup is that I need to also
add a mergefield that adds attatchments to the email. I am stuck. I put a
mergefield in the word document and added the field to the worksheet, but
it's not pulling anything when I just go through the mail merge toolbar
buttons. Any help would be great. Thanks!

 

[Peter Jamieson]

Using the out-of-the-box facilities, you can merge to email using a plain
text or HTML body and no atttachments, or with a completely blank message
with an attachment, but not both.

For a method of e-mailing with attachments, see Doug Robbins' article at

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

Peter Jamieson

 

[Michelle Hanan]

So far I have an email field that sends the document fine....but is there
any way to stop the email before it is sent so I can add an attachment that
way?

 

[Peter Jamieson]

The only way I know that's likely to work is to set Outlook so it does not
send, do the merge, open each e-mail in the Outbox, add the attachment, then
eventually re-enable Outlook so it sends. I don't know of a way that lets
you interrupt a merge to email - you would have to do /something along the
general lines/ of the code in Doug's article to do that.

Peter Jamieson