Perform a Microsoft Word Mail Merge from Within Excel

Learn to merge data from Excel into Word

Computer keyboard with Mail button being pressed.

TARIK KIZILKAYA / Getty Images

The mail merge feature in Microsoft Word and Excel simplify the process of sending the same document—but with personalized changes—to several recipients. The term "merge" comes from the fact that one document (a letter, for example) is merged with a data source document, such as a spreadsheet. We'll show you how to do it.

This guide applies to Word for Office 365, Word 2019, Word 2016, Word 2013, and Word 2010.

Prepare the Data for Mail Merge

Word's mail merge feature works seamlessly with data from Excel. While Word also allows you to create a data source, options for using this data are limited. If you already have your mailing list data in a spreadsheet, it doesn't make sense to retype all the information into Word's data source.

Theoretically, any Excel worksheet can be in a Word mail merge function without any special preparation. However, you should take some time to prepare your worksheet to optimize the mail merge process.

Screenshot of Excel showing data ready to be merged in Word

Organize the Spreadsheet Data

Your Excel mailing list data should be organized neatly into rows and columns. Think of each row as a single record and each column as a field you are going to insert into your document. If you need a refresher, check out an Excel data-entry tutorial.

Create a Header Row

Create a header row for the sheet you intend to use for the mail merge. A header row is a row containing labels that identify the data in the cells beneath it. Excel can be finicky sometimes about differentiating between data and labels, so make these clear by using bold text, cell borders, and cell shading that are unique to the header row. This ensures that Excel differentiates it from the rest of your data.

Screenshot of Excel showing header data

Later, when you merge the mailing list data with the main document, the labels appear as the names of the merge fields. This eliminates any confusion as to what data is inserted into your document.

It's a good practice to label the columns in your Excel worksheet. It helps prevent errors in the future.

Put All Data on a Single Sheet

The mailing list data you intend to use for the mail merge must be on one sheet. If it's spread across multiple sheets, combine them or perform multiple mail merges. Also, make sure the sheets are clearly named, as you have to select the one you intend to use without viewing it.

Associate a Data Source in a Mail Merge

Here's how to associate your prepared Excel worksheet containing your mailing list with your Word document:

  1. In Word, select Mailings > Start Mail Merge.

    Screenshot depicting the Start Mail Merge options in Word 365
  2. Choose the kind of merge you want to run from the drop-down list.

  3. Go back to the Mailings tab and hit Select Recipients > Use an Existing List.

    Screenshot of Word showing how to insert an existing list
  4. Find your Excel file, then press Open.

  5. If Word prompts you, choose Sheet1$ > OK.

If your Excel has column headers, ensure the First row of data contains column headers option is checked.

Edit the Mailing List

By now, your Excel spreadsheet should be connected to the mail merge document you’re creating in Word. So, it's time to edit your Word document.

You can't make changes to your data source in Excel at this time. If you need to make changes to the data, close the document in Word before opening the data source in Excel.

Insert Merge Fields into Your Document

In Word, select Mailings > Insert Merge Field to pull information from your spreadsheet into your document. Choose the field you want to add (first name, last name, city, state, etc.) and select Insert.

Screenshot of Excel showing the insertion of Merge Fields

View Mail Merge Documents

Word doesn't carry over formatting from the data source when inserting merge fields into a document. If you want to apply formatting such as italics, bold, or underline, you must do so in Word.

If you're viewing the document with fields, select the double arrows on both sides of the field where you want to apply the formatting. If you're viewing the merged data in the document, highlight the text you wish to change.

Any formatting changes are carried throughout all the merged documents, not just the individual one.

Preview the Merged Documents

To preview the merged documents, select Preview Results on the Mailings tab. This button works like a toggle switch, so if you want to go back to viewing just the fields and not the data they contain, press it again.

Navigate through the merged documents using the buttons on the Mailings tab ribbon. They are, from left to right: First RecordPrevious RecordGo To RecordNext Record, and Last Record.

GIF showing data merged into Word

Before you merge the documents, preview them all, or as many as you can, to verify that everything merged correctly. Pay particular attention to punctuation and spacing around the merged data.

Finalize the Mail Merge Document

When you're ready to merge the documents, you have two choices:

  • Print Documents: The first is to merge them to the printer. If you choose this option, the documents are sent to the printer without any modification. Do this by selecting Mailings > Finish & Merge > Print Documents
  • Edit Individual Documents: If you need to personalize some or all of the documents (although, you would be wise to add a note field in the data source for personalized notes) or make any other changes before you print, edit each individual document. To do this, select Mailings > Finish & Merge > Edit Individual Documents.
Screenshot of Word showing the Print option for Mail Merge

Whichever method you choose, you are presented with a dialog box where you can tell Word to merge all records, the current record, or a range of records. Choose the records you want to print and select OK.

If you want to merge a range, enter the beginning number and the final number for the records you want to include in the merge and select OK.