• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 44
  • Last Modified:

Word Mail Merge to Email

I want to email a word mail merge document to multiple recipients as a attachment.  This is fine and I have tested this fine but there is not in word the facility to put anything in  the body of the email while doing the merge.  This does not need to be variable per email more of a :

Dear Attendee

Please find attached your invoice for the . . . . . .

We look forward to seeing you.


1 Solution
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello pfarnell

>> I want to email a word mail merge document to multiple recipients as a attachment.

I'm not quite sure I understand this. Do you want to send a mail merge document as an attachment? Or do you want to do a mail merge into email with an attachment?

You can do a Mail Merge to email from Word. Up to Word 2003 you can not attach a file in a merge to email, though.

If you just want to send a Word document as an attachment to a list of people, without any personalised content in the email, just create an email, attach the document and put the email addresses into the BCC field. Put your own email into the Send To field and send it off.

cheers, teylyn

pfarnellAuthor Commented:
I want to email a personalised word document as an attachment which I can do easily enough.  However I also want to have a standardised text in the body of the email.
As far as I'm aware, word has no facility to include mail templates within the 'Send to' options apart from the pre-defined message seen when going 'Send to > Mail Recipient (for Review)'

The only way is if your mail client supports mail templates, that way you can set out any email as you like and save it for future use. Then you simply need to attach the word document and send it off.
Any luck?
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now