}

Perform a Mail Merge with Word and Excel

Mail merge can be used to create multiple documents simultaneously from various sources. The documents have identical layouts, formatting, text, and graphics. For personalization, specific sections of each document vary with individual content. Word can create documents with mail merge, including letters, envelopes, bulk mailing labels, and emails. There are three component documents involved in the mail merge process:

  • The main document is your template.
  • The data source for personalized information
  • Your merged document, which is the result of both personalized and standardized content
Human resources abstract concept vector illustration

Word and Excel Mail Merge Step by Step

First Step: Prepare personalized data in Excel for mail merge

The first and most crucial step in the mail merge process is to set up and prepare your personalized data. We will use an Excel spreadsheet as the data source for the recipient list.

Here are some recommendations to prepare your personalized data for a mail merge process. Please ensure the following:

  • Column names in your Excel spreadsheet must match the fields you want to insert in your mail merge Word document. For example, you'll need separate data columns for first and last names to use a person's first name in your document.
  • All data to be merged must be present in the first worksheet of your Excel spreadsheet.
  • Data entries with currencies, percentages, and zip codes are correctly formatted in the spreadsheet so Word can adequately read the values.
  • The Excel spreadsheet file to be used in the mail merge is stored on your local machine or is accessible on a shared network folder.
  • Changes or additions to your spreadsheet must be completed before processing your mail merge document in Word.

Second Step: Start the Word mail merge process from the Ribbon Menu

  • In Word, choose File > New > Blank document.
  • On the Mailings tab, in the Start Mail merge group, choose Start Mail Merge and choose the merge you want to run.
mail merge screenshot 01
Screenshot of the Mailings tab in Word, showing the Start Mail Merge command and the list of available options for the type of merge you want to run.

  • Choose Select Recipients > Use an Existing List.
mail merge screenshot 02
  • Locate your Excel spreadsheet, and then choose Open.
  • When Word prompts you, choose Sheet1$ > OK

Edit the mailing list.

Select who receives your mail.

  • Choose Edit Recipient List.
mail merge screenshot 03
Screenshot of the Mailings tab in Word, showing the Edit Recipient List command as highlighted.
  • In the Mail Merge Recipients dialog box, clear the check box next to the name of anyone you don't want to receive your mailing.
  • Select rows by checking the check box
mail merge screenshot 04

Third Step: Insert a merge field

You can insert one or more mail merge fields that pull the information from your spreadsheet into your document.

To insert an address block for an envelope, a label, an email message, or a letter

  • On the Mailings tab, in the Write & Insert Fields group, choose Address Block.
mail merge screenshot 05
  • Insert Address Block merge field
mail merge screenshot 06
In the Insert Address Block dialog box, please choose a format for the recipient's name, as it will appear on the envelope.
  • Choose OK
  • Choose File > Save

Fourth Step: Preview and finish the mail merge

After you insert the merge fields you want, preview the results to confirm that the content is okay. And then, you're ready to complete the merge process.

  • On the Mailings tab, choose Preview Results.
mail merge screenshot 07
Screenshot of the Mailings tab in Word, showing the Preview Results group.
  • Choose the Next Next record button for mail merge preview results or Previous Previous record button for mail merge preview results record button to move through records in your data source and view how the records will appear in the document.
  • In the Finish group, choose Finish & Merge, and choose Print Documents or Send Email Messages.
mail merge screenshot 08
Screenshot of the Mailings tab in Word, showing the Finish & Merge command and its options.

Well, I am done! As a final step, you can save this mail merge for use in the future.

 

Have the power of project management, data analysis, and software development at your fingertips with Microsoft 365 training.

 

This piece was originally posted on August 30, 2018, and has been refreshed with updated styling.