Mail Merge in Word From Excel: Step-by-Step Guide

To mail merge in Word from an Excel file, prepare a clean list with one recipient per row, then in Word choose Mailings > Select Recipients > Use an Existing List, connect the workbook, insert merge fields, preview the results, and finish the merge. You will need the desktop versions of Excel and Word, plus a saved workbook with column headings.

What You’ll Need

A Microsoft Excel workbook saved as an .xlsx or .xls file.
A recipient list with a header row and one person or organization per row.
Microsoft Word for Windows or Mac. Word for the web does not provide the full desktop mail merge workflow.
A Word document to use as the letter, label sheet, or email message template.

Step-by-Step

Set up your Excel recipient list. Put each type of information in its own column, such as FirstName, LastName, Address, City, and Email. Use a single header row at the top, with a distinct name for each column. Put one recipient on each row and avoid blank rows or columns inside the list. Do not merge cells, and keep notes or totals outside the recipient data. For example, a header row followed by three recipient rows is easier for Word to interpret than a formatted report with subtotals and several header lines.
Check values that need special formatting. Make sure names and addresses are spelled correctly, and check that postal codes, phone numbers, and account numbers retain leading zeroes. Excel may remove initial zeroes from numeric values; if a value must be preserved exactly, format that column as Text before entering or importing the data. Dates and currency can also appear differently in Word than they look in Excel, so inspect them carefully later in the preview. Save the workbook, then close it before connecting it to Word to reduce the chance of file access or stale-data problems.
Open or create the Word template. Start a new document for a letter, or open the document you want to personalize. Type the parts that will be the same for everyone, such as your return address, greeting text, and closing. Leave the spots for recipient-specific information ready for merge fields. In Word for Windows, select the Mailings tab on the ribbon. Word for Mac also has a Mailings tab, although the placement and appearance of some controls can vary by release.
Choose the kind of merge. In Word for Windows, select Mailings > Start Mail Merge, then choose Letters for personalized documents, E-mail Messages for individual email messages, or Labels for address labels. Choose the type that matches the document you are making. For labels, select the label vendor and product number when prompted, so the layout matches the physical sheet. Word for Mac offers the same general mail merge choices from Mailings, but its dialogs may look different.
Connect the Excel workbook. Select Mailings > Select Recipients > Use an Existing List. Browse to the workbook, select it, and choose Open. If Word asks you to select a table or sheet, choose the worksheet containing the recipient list. Confirm that the option indicating the first row contains column headers is selected, if it appears. If you made an Excel table, Word may show the table name as a source choice. For Windows, the data connection dialog may include other options depending on installed Office components; choose the worksheet or table that holds the complete list.
Insert fields where personal details belong. Click in the document at the position for a recipient value. Choose Mailings > Insert Merge Field, then select the appropriate column, such as FirstName or Address. A field appears in the document, usually displayed with chevrons, for example «FirstName». Add punctuation and spaces around fields as needed. A greeting might read Dear «FirstName» «LastName»,. You can also use Mailings > Address Block or Greeting Line to build common blocks, then select Match Fields if Word has not matched your Excel column names correctly.
Preview the merged records. Select Mailings > Preview Results. Word replaces the field names with values from the list. Use the left and right record arrows in the Mailings ribbon to inspect several recipients, including the first and last records. Check line breaks, spacing, punctuation, names, addresses, and number or date formatting. If a field is blank or shows the wrong value, turn off Preview Results and correct the field or the source data before proceeding. This preview shows records one at a time; it does not yet create the final set of documents.
Complete the merge and check the output. Select Mailings > Finish & Merge. For letters, choose Edit Individual Documents to create a new document containing the merged results, or choose Print Documents to print them. Editing the combined document first gives you a chance to review page breaks and individual results. For labels, use the same finish options and check a test page against an unused label sheet before printing a full batch. For email, choose Send Email Messages, select the email column in the To box, enter a subject, and choose the message format. Email sending requires a compatible desktop email setup; check your organization’s Outlook configuration if the command is unavailable. Standard email merging sends separate messages and does not attach a file to each message.

Common Mistakes

Using a worksheet with extra headings or blank rows: Word can mistake a title or an empty line for part of the data range, or skip records. Keep the list rectangular and put the field names in the first row of the selected range.

Choosing the wrong worksheet: A workbook may contain several tabs. Confirm that the selected sheet includes both the headers and all intended recipients. If Word shows unexpected field names, reconnect to the correct sheet or table.

Expecting Excel’s display formatting to carry over exactly: Word may not display dates, currency, or numbers as they appear in Excel. Preview the merge and, where practical, store identifiers such as postal codes as text. Never assume a column of numbers is safe just because its cells look right in the workbook.

Printing before checking the complete result: A field can be correct in the first record but missing or oddly spaced in another. Preview multiple records, and use Edit Individual Documents when you want to inspect the full output before printing or sending.

Tips

Use short, descriptive header names with no duplicate headings, such as FirstName and PostalCode. These names are easier to recognize in Word’s Insert Merge Field menu.
Convert the recipient range into an Excel table with Insert > Table if you expect to add records later. Check that the table includes the header row and all recipients before connecting it.
Keep one master workbook and make changes there. If you edit the source after connecting, save and close it, then reopen or reconnect the data source in Word if the preview does not reflect the updates.
For a first run, use a small copy of the list or select a limited set of records in Mailings > Edit Recipient List. This helps catch layout issues without producing a large batch.
Use Mailings > Rules for conditional content only when needed, such as different wording for recipients in different regions. Keep the basic merge working before adding rules.
For labels, print a test on plain paper and hold it over the label sheet to check alignment. Confirm the printer’s scaling is set to actual size rather than fit to page.

Troubleshooting

The workbook or worksheet is not listed: Verify the file is saved locally or in a location you can access, close it in Excel, and browse to it again. If the workbook is in a cloud folder, wait for it to finish syncing. Confirm that the data is on a worksheet and that the file is not password-protected in a way that blocks Word’s connection. On Mac, file picker and connection prompts differ from Windows; use the workbook selection dialog in Word’s Mailings workflow rather than trying to insert the spreadsheet as an object.

Word shows column names instead of values: Turn on Mailings > Preview Results. If the field names remain visible, check that the document is connected to the intended list and that the correct sheet or table was selected. Reinsert the field from Insert Merge Field if it was typed into the document manually; typed text that resembles a merge field is not a real field.

Some recipients are missing: Open Mailings > Edit Recipient List and check whether records are excluded by a filter or an unchecked selection box. Also inspect the source sheet for blank rows that split the data range. Reconnect after correcting the workbook if Word continues to use an earlier range.

Dates, postal codes, or amounts look wrong: Correct the source column’s underlying values and formatting, then refresh the data connection. Postal codes and similar identifiers should generally be stored as text so leading zeroes remain. If a date or number needs a particular presentation, review the merged result and adjust the Word field formatting or prepare a separate display-ready text column in Excel.

Labels do not line up or email sending is unavailable: For labels, confirm the exact product number, paper size, and printer scaling, then test on plain paper. For email, verify that an email address field is selected in the To box and that Word is connected to a compatible desktop mail account. If your organization uses a newer Outlook setup that does not work with the merge command, check with its administrator or use a supported desktop configuration; you can still merge letters or labels instead.

Frequently Asked Questions

Can I mail merge from Excel to Word online?
Use the desktop Word application for the full mail merge process. Word for the web can open and edit many documents, but it does not provide the same complete set of mail merge controls as Word for Windows or Mac.

Do I have to sort the Excel list first?
No. Word can merge records in the order they appear in the selected list. Sort the source in Excel if you want a particular order, or use the recipient list options in Word to filter or sort the records for a merge.

Can one Excel file contain multiple mailing lists?
Yes. Keep each list on a separate worksheet or in a separate Excel table, with its own clear header row. When connecting from Word, select the correct sheet or table and preview records to confirm you chose the intended list.

Can I merge only selected recipients?
Yes. Choose Mailings > Edit Recipient List, then use the checkboxes, sorting, or filtering options to control which records are included. Preview the first and last included records before finishing.

Will the merge send emails with attachments?
The standard Send Email Messages merge creates an individual email for each selected recipient, but it does not add a unique attachment to each message. Use another approved mail tool or workflow if attachments are required.

Can I update the Excel list after building the Word document?
Yes. Save the changes in Excel, close the workbook, then reopen or reconnect the data source in Word and check Preview Results. If Word still shows old values, select the source again through Mailings > Select Recipients.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.