Knowledgebase: Office 365 > Outlook Client
How To mail merge using Outlook, Word, and Excel to do Mass Mailings
Posted by , Last modified by on 16 May 2018 06:32 PM

Set up your mailing list

The mailing list is your data source. It can be an Excel spreadsheet, a directory of Outlook contacts, an Access database, or an Office address list. It contains the records that Word uses to pull information from to build your letter.

Tips

  • If you don’t have a mailing list, you can create one during mail merge. Before you start the mail merge process, collect all of your data records, and add them to your data source.
  • If you're using an Excel spreadsheet, make sure the column for ZIP Codes or postal codes is formatted as text so that you don't lose any zeros.
  • If you want to use your Outlook contacts, make sure Outlook is your default email program

Prepare the recipients list

  • You should store all of the recipient's information in an Excel spreadsheet.
  • The first row of the spreadsheet should contain column headings such as First Name, Last Name, and Email Address.
  • Each recipient's email address must be in a column by itself without the full name, angle brackets, quote marks, or other special characters.
  • Each recipient's information must be listed on a separate row.
  • Row and column example with column headings:

      

Prepare the email message
  1. Start Microsoft Word and begin a new blank document.
     
  2. Switch to the Mailings ribbon.

  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.
  6. In the Select Table window, click on the name of the sheet that contains your recipient's information.
    1. If you have options for Sheet1, Sheet2, and Sheet3, the information is probably on Sheet1.
    2. If you entered column headings in the first row of your spreadsheet, make sure the First row of data contains column headers option is checked.
    3. Click on the OK button.
  7. Compose the body of your message using Word
    • You can switch back to the Home ribbon to add formatting including bold, italics, font colors, and headings.
    • Not all formatting will visible to all recipients. Outlook users will see most of the formatting. Web mail users will see bold, italics, and lists but not font styles or colors.
  8. To customize the contents of your message with information from your spreadsheet:
    • Position the cursor where you want to insert the data.
    • Switch to the Mailings ribbon.
    • Click on the Insert Merge Field menu and select the field containing the data you want to insert.
  9. Save the body of the email message the same way you would save any other Word document.

Send the email messages

  1. Switch to the Mailings ribbon.
  2. Click on the Finish & Merge menu and select the Send E-Mail Messages option.
  3. From the To drop-down menu, select the field containing the email address of each recipient.
  4. In the Subject text box, enter the subject line used for the email message.
  5. From the Mail format drop-down menu, select the HTML option.
  6. For the Send records radio button, select the All option.
  7. Click on the OK button to send the messages.

Email Merge Tips
  • If you customize the message for each recipient, use the Preview Results button on the Mailings ribbon to see the data from your spreadsheet in the body of the message instead of the field names. Use the arrows to right of this button on the ribbon to preview different records from your spreadsheet.
  • Customizing the email message for each recipient is easiest when the information is split into several columns. For example keeping the first name and last name in separate columns is better than keeping them in a single column called name. You can always put two fields together in your message, but pulling fields apart is much more difficult.
  • If you send newsletters or flyers as PDF attachments, consider publishing the PDF on your website and then using email merge to send a notice with a link. Later you can check your website's statistics to determine how many people downloaded the PDF.
  • You may want to add yourself as the first recipient in your spreadsheet so you can test the message delivery. Use the Preview Results button to view the message you will receive. Follow the sending instructions, but change the Send Records option from All to Current. This will send only the message currently being previewed through Outlook.