Sending Out Unique Attachments to each Recipient using EmailMerge

By: Standss Contributor , Feb 2nd, 2021

Do you need to email a list of contacts a “similar” email but with a different attachment for each person? For example: maybe you need to send out invoices (pdf files) to all your current customers.

This is easy to do in Outlook with a little help from EmailMerge.

EmailMerge is a mail merge add-in for Microsoft Outlook that allows you to send mail merges directly from Outlook. You can use EmailMerge to perform mail merge with attachments in just two easy steps:

Step 1: Create a contact (and attachment list) using Excel.

Step 2: Use EmailMerge to write and send out the email to the list you created in Step 1 (a separate email with different attachment will be sent to each person in your list).

If you are not EmailMerge user, you can download a free 30-day free trial (no credit card information needed).

Step 1: Create a contact (and attachment list) using Excel

You will need to create a list in Excel. This will be a list of the people that you want to send the email to, along with the full filename (including the path) of the file you want to send to each person as shown below.

This Excel file will later be used to do mail merge with attachments using EmailMerge.

Start a new spreadsheet in Microsoft Excel.

Select Blank workbook.

The first row of the spreadsheet should have the names of the fields as shown.

You must have a field with the email address.

If you are sending attachments too, then you must have a field with the FILE PATH of the file that you want to send as shown.

You can add additional columns/fields to the spreadsheet if you want.

Save the spreadsheet and close Excel.

Step 2: Use EmailMerge to write and send your email from Outlook

Once you’ve installed EmailMerge, you can find it under the Home tab ribbon or through the Standss addins tab in Outlook.

Click on EmailMerge in the Outlook Ribbon

Click on Create a new Merge.

You can choose whether to start your email merge process with a Blank email (see Step 2) or select an Email template (pre-set email) you created.

Select Start with Blank email and Click Next.

You will edit this email later.

Select the Excel File option from the list and use the Browse button to select the Excel file which you created in Step 1.

Click Next.

Select the sheet from the screen and click Next.

Select the correct fields from the drop-downs on the screen (at the minimum, you need to select the correct field for Recipients Email Address)

Click on the Select fields for Attachments/CC/BCC link as shown.

Click on the Attachments tab

Tick the appropriate field which has the path and filename of the attachments for each recipient. In my case, I will tick the checkbox “Attachments” (Please refer to the image above)

Click OK to go back and then click Next.

Select the people to whom you want to send this email.

Click Next.

Email Merge will display a list of all contacts you had selected to be added to your current sending list.

You can verify and confirm your list here. Click Next.

Here you can define rules for how Email Merge for Outlook handles missing contact fields.

Click Next.

Click on the Go to Email to Edit button to edit the email.  Click Next.

Creating your Mail Merges

A new email window will appear.

Write whatever you want to in the Subject and Body of the email but do not enter anything in the To field.

You can now insert m-Fields in your email. m-Fields are basically place holders that will be replaced with real data when the emails get created (in the example, we have a field called [First Name] that is later replaced with the real first names from the list).

On the EmailMerge toolbar select from the drop down Field, the field you want to insert and click Insert m-field.

Add any more m-fields that you want to the email (you can add m-fields to the Subject or Body of the email).

Once done click Send to go back to EmailMerge.

You can preview your emails on this screen. The preview shows who the email is going to, the attachment and any other customizations that you had set up earlier.

Once your email is ready, click Next.

Here you can configure some sending options and choose the Email Account to send the emails from

Select whether you want the email to be sent out immediately or sent out later (saved in the drafts folder)

Click Finish to let the wizard complete.

After you have successfully completed, you will see that separate emails for each of the recipients that you selected have been created in your Outbox or Drafts folder.

These emails contain the message that you typed together with the “m-Fields” being replaced with the actual details of each of the recipients. Each of the emails will also have the correct attachment added to it based on your Excel list.

And that’s it…. thousands of users use EmailMerge for Outlook everyday to send out their sales and marketing emails. If you are not a user yet,  you can download a fully functional 30 day trial version to test it for yourself.

Image Credit:

Image by freepik

2 Replies to “Sending Out Unique Attachments to each Recipient using EmailMerge”

  1. Would you have the screenshots for Outlook 365 please? These appear to be on earlier version of outlook

  2. Hi Sudha,

    Note that Unaisi has replied to your email.

    You can reply to her email if you have any further queries.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Recent Posts


Get the free eBook

© , Standss (South Pacific) Limited. All Rights Reserved.