How to Email Merge personal data and attachments

  AroundAgain 12:08 10 Apr 2018


I believe this is likely to be a bit complex and rather challenging (for me, at least) so I'll try to be clear.

I have Windows 10, and MS Office Pro 2010 so using Word 2010 to create merged documents, Access 2010 for data and Outlook 2010 to send the emails from

I need to email personal details (so NOT in the body of email) using Email Merge, plus two attached pdf documents to approx 100 recipients.

I am aware of Mail Merge Toolkit ($25) ? GBP and Outlook Mail Merge Attachment (OMMA) Free but I'm not sure either will do what I need. I've not used either of these. I have previously tried Doug Robbins' download but it won't do the email merge to an attached document,as far as I know.

So, ideally, I'd like a short message in the body of the email, the merged data in an attached document (which recipient is asked to complete form and return (can print off, complete then scan/email or post) They will have option to ask for postal copy and SAE if they prefer. Two other documents, either Word or (preferably pdf) must also be attached.

I'm not sure this is possible but has anyone any ideas, suggestions, work-around etc. Obviously, the easy way would be to post them all but cost is a factor to be considered.

Many thanks for any help. Please ask if you need further information

  AroundAgain 10:43 11 Apr 2018

Oh dear, looks like I've asked the impossible.

It looks as if my best option is snail-mail after all

Thanks for reading my post anyway.

  alanrwood 19:38 11 Apr 2018

I have been trying to find out how to do this for years without success so if you come up with anything please get back.

  AroundAgain 19:58 11 Apr 2018

Hi Alan

Have you looked at OMMA, link is above? If I knew how to mail merge and save merged documents as pdf, I think this would suit me well. Maybe I should investigate how to do just that?

Apparently MailChimp will do this and there is a free version available but has a limit on the number of emails you can send out. I believe it's an online service so not appropriate for my my situation. It might be suitable for your needs, tho. Perhaps worth looking into?

So, likewise, if you manage to find a work-around / way to do this, please let me know too ;)

Thanks for posting

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy Fold review: Hands-on

Best Wacom deals for Easter

iMac 21.5in (2019) review

Comment faire pivoter une vidéo ?