Outlook mail merge - personalize email messages

Posted on:  01/02/2017
Outlook mail merge - personalize email messages

You can send an email message out to a contact group (distribution list), or just manually put everyone on the TO or BCC line, but if you want to personalize each recipient’s email message, you need to do a mail merge. Why would you want to do this? If you have 300 customers with Sales Reps, and the Reps are changing which customers they serve, you would email all the customers and include the new Sales Rep contact information.

I’m going to demonstrate how to do an email mail merge using Microsoft Outlook. The advantage of personalizing the email message is the recipient is more likely to read it. This is a great tool for emailing customers, vendors, contractors, invitations to corporate events, or even employees.

There are three things required to do this. All three are part of Microsoft Office. This works in Office 2007, 2010, 2013, and 2016. What you need:

  1. Microsoft Excel
  2. Microsoft Word
  3. Microsoft Outlook

Microsoft Excel – data source

I recommend you put your data source in Excel. If you were emailing customers, this information would probably include First Name, Last Name, Title, Company, Sales Rep, email address, etc. See the image below.

Customers mail merge

YouTube video on email mail merge

Microsoft Word – perform email mail merge

All mail merges are done in MS Word. After creating your Excel file, start MS Word and do the following. This happens at 00:32 in the video above.

  1. Start MS Word.
  2. Switch to the Mailings Tab.
  3. Click on the Start Mail Merge menu and select the E-Mail Messages option.
  4. Click on the Select Recipients menu and select the Use Existing List option.
  5. Browse and select the Excel spreadsheet you created earlier, and then click on the Open button. Select the correct worksheet from Excel.
  6. Compose the body of your message using Word
  7. Insert Merge Field menu and select the field containing the data you want to insert.
  8. Click on the Finish & Merge menu and select the Send E-Mail Messages option. Add a Subject to your emails.

Photo gallery of the steps above

Mail Merge 1

Mail Merge 2

Mail Merge 3

Mail Merge 4

Mail Merge 5

Microsoft Outlook

The last step is to go to Microsoft Outlook, click on the Sent folder and you should see all the emails that were sent. Each recipient should receive a personalized email message.

Disadvantages of sending Mass Emails

There are some disadvantages to doing a mail merge.

  1. It is much simpler to send the message and place the recipients on the TO or BCC Line of the message.
  2. If you need to email out 500 personalized email messages, your server at work or ISP may not allow it. Usually, there is a daily cap on the number of email messages you can send per day.
  3. You must have a data source, like an excel file for your recipients. It is possible to do the mail merge using Outlook Contacts or People but you are limited to the fields you can include in your mail merge.
Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories