Forum Discussion
Way to mail merge to send attachments
1. Use Word's Mail Merge feature to create emails.
2. If you need to add attachments, you can add them manually, email by email, or use a third-party tool (such as Mail Merge Toolkit or AbleBits Mail Merge) to add attachments automatically.
3. Ensure that the data source contains a field for the path or filename of the attachment so that it can be referenced during the merge.
4. if the mail volume is small, adding attachments manually is a simple and straightforward method; if the mail volume is large, it is recommended to use a third-party tool to improve efficiency.”
Thanks for the reply. I'm OK with doing mail merge and adding the attachments manually. I was trying to see if there was a way to automate it more within the Outlook environment. Thanks for your tips. Much appreciated.
How do you add them manually please?
1) Prepare your Mailmerge as normal in Word as if you were going to mass-send emails without attachments.
2) In Outlook, set yourself to work offline:
3) In your Word document, click "Finish & Merge", then "Send Email Messages". A dialogue box opens. In the "To:" field, select the field in your contacts list that contains the email addresses to which you'd like to send the emails.
Click OK. Because you set Outlook to work offline in step 2, those emails will be stored in the "Outbox" folder of your Outlook rather than being sent immediately to recipients.
4) Go to your "Outbox" folder, open emails and add attachments as desired, and click "Send" to close that email and queue it to be sent.
5) Set Outlook back online and the emails in your Outbox folder will be sent
