How to Fix Mail Merge in Word: Fields, Data, and Printing

To fix mail merge in Word, check that your recipient list has clear column headers and valid records, reconnect the data source, match the document’s merge fields to the right columns, and use Preview Results before finishing the merge. You will need the desktop version of Word and access to the source file, such as an Excel workbook or CSV. These steps are for Microsoft 365 on Windows; the Mailings tab is also available in Word for Mac, though some dialogs and file-picker options may look different.

What You’ll Need

Microsoft Word for Microsoft 365 desktop. Word for the web does not provide the full desktop mail-merge workflow.
Your recipient data in an Excel workbook or CSV file, with one row of column names followed by one recipient per row.
The Word document you want to use, or a new document for the merge.
Permission to access the data file, particularly if it is on a network, in OneDrive, or in SharePoint.

Step-by-Step

Save and inspect the data source. Open the Excel workbook and check that the recipient list is a simple table: headers in the first row, one recipient on each following row, and no completely blank rows or columns inside the list. Use distinctive headers such as FirstName, LastName, Email, and PostalCode. Remove merged cells, totals, notes, and duplicate header rows. Save the workbook, then close it before reconnecting from Word. Closing it can prevent access conflicts and makes sure Word reads the latest saved version. If you use CSV, check that it opens with the columns separated correctly and save it in a location you can find.
Check that important values have not been changed. In Excel, inspect dates, amounts, phone numbers, and postal codes. Excel may remove leading zeros from a number such as 00421 or interpret an entry as a date. Set postal-code and phone-number columns to Text before entering or importing values when their exact characters matter. If a zero has already disappeared, formatting the cell as Text afterward will not restore it; recover the original value from the source data.
Reconnect Word to the correct list. Open your merge document in desktop Word and select the Mailings tab. Choose Select Recipients > Use an Existing List, browse to the current Excel or CSV file, and select it. For an Excel workbook, choose the worksheet or named range that contains the recipients. If prompted, confirm that the first row contains column headers. If the source has changed location or name, reconnect rather than relying on the old link.
Confirm the recipient records Word will use. Select Mailings > Edit Recipient List. Check that the expected names and records appear, and make sure the checkboxes are selected for the people you want included. Use the sorting, filtering, or checkboxes in this dialog to narrow the list if needed. If the list is empty, shows the wrong sheet, or includes headings as a record, return to the source file and correct its structure, save it, then reconnect it.
Check the merge type and layout. On the Mailings tab, select Start Mail Merge and choose the intended type, such as Letters, E-mail Messages, or Labels. A label document also needs the correct label vendor and product under Start Mail Merge > Labels. If the wrong type was selected, choose the right one before adjusting fields; letter layout and label layout do not behave the same way.
Repair or insert merge fields. Click where a value should appear, then select Mailings > Insert Merge Field and choose the matching column. For example, insert FirstName where the greeting needs a first name, not Email or LastName. If an existing field is wrong, remove it and insert the correct one. Do not type angle-bracket placeholders such as «FirstName» by hand: a real merge field is linked to the data source, while typed text is not. For a full address, use Mailings > Address Block; use Match Fields in its dialog if Word has not identified your address columns correctly.
Preview several records. Select Mailings > Preview Results, then use the previous and next record arrows beside the preview control to inspect multiple recipients. Check the first, a middle record, and the last one. Look for blank fields, wrong names, punctuation, unexpected line breaks, missing leading zeros, or a greeting that does not fit every record. Turn off Preview Results to return to the field view when you need to edit the template.
Complete the merge in a safe way. When the previews look right, choose Mailings > Finish & Merge. Select Edit Individual Documents to create a separate merged document you can proofread, or Print Documents to send the results to a printer. For a small test, use the option to merge the current record or a limited range if available in the dialog. For email messages, choose Send E-mail Messages and confirm the To field, subject line, and mail format before sending. Keep the original template and data file unchanged until you have checked the output.

Common Mistakes

Using typed placeholders instead of merge fields. Text that looks like a field name will remain unchanged in the final document. Insert fields through Mailings > Insert Merge Field.

Changing the source after connecting it. If you rename a column or move the workbook, Word may show missing fields or continue using an old location. Save the source and reconnect it through Select Recipients > Use an Existing List.

Leaving blank rows in the recipient list. Blank rows can appear as empty recipients or disrupt the range Word reads. Keep the data block continuous and remove blank rows between records.

Trusting one preview. A first record may have a complete address while later records have missing apartment numbers or different name formats. Preview multiple records before printing or sending.

Expecting Excel display formatting to carry over. Word may display a date, percentage, or number differently from its appearance in Excel. Check the merged result, and where a value is critical, prepare it as the exact text you want to display in the data source.

Tips

Make a copy of both the Word template and recipient file before changing a complex merge. A copy gives you a quick way back if field edits or source cleanup go wrong.
Use short, unique column headers without punctuation where practical. Headers such as FirstName and OrderDate are easier to recognize than repeated labels such as Name or several columns all called Address.
For labels, select the correct label product before inserting fields. Build the first label, then use Mailings > Update Labels so the layout and fields are repeated across the sheet.
If an address block puts information in the wrong place, open its settings and use Match Fields to connect Word’s address components to your actual headers. Preview a record with an unusual address as well as a standard one.
For large print jobs or email batches, create a merged document first and proofread it. That makes it easier to catch a bad greeting, extra blank page, or misplaced field without producing hundreds of copies.
On Mac, use the Mailings tab for the same core tasks, but expect the file chooser and some dialog layouts to differ from Windows. If a source file is not offered or does not connect, save it locally as an Excel workbook or CSV and select it again from Word.

Troubleshooting

Word says it cannot find the data source: Verify the workbook still exists at the linked location and that you have permission to open it. In Word, reconnect through Mailings > Select Recipients > Use an Existing List. If the file is stored online, try a synced local copy or download it, then connect to that copy.

Merge fields are missing or show an error: The selected sheet may not contain the columns used in the template, or its headers may have changed. Reopen Edit Recipient List to confirm the selected data, then delete and reinsert any field that no longer matches. Avoid renaming source headers after the merge fields are in place unless you are ready to repair them.

Every recipient gets the same information: Confirm that you used Preview Results and moved through the records. If the final merged document still repeats one person, reconnect the list and confirm that Word recognizes separate data rows. Also check that you did not accidentally choose to merge only the current record.

Some recipients are missing: Open Edit Recipient List and inspect the selected checkboxes and any filters. Clear filters or select the missing records, then preview again. Check the source for blank rows, and make sure Word is connected to the worksheet containing the complete list.

Dates or numbers look wrong: First compare the preview with the source values. If Excel changed the underlying value, correct it in Excel and reconnect the list. If the value is correct but displays differently, make a text-formatted display column in Excel for the merge, such as a date written in the exact style you need. This is often easier to maintain than relying on Word to infer the intended format.

Labels only fill the first position: Choose the label type before inserting fields, then use Update Labels on the Mailings tab. Check that the next-label positions contain the repeated fields and that the page setup matches the label sheet. Print a test on plain paper and compare it with the label stock before printing labels.

The merge hangs or produces a very large document: Test with a small recipient range first, close other applications, and save the merged output to a local folder. Large images or complex formatting repeated for every record can increase the output size. If the file is still slow, simplify the template and merge smaller batches.

Frequently Asked Questions

Why does mail merge show field names instead of recipient information?
That is normal before previewing. Select Mailings > Preview Results to display values. If the names remain, confirm that the fields were inserted with Insert Merge Field and that Word is connected to the right list.

Can I use an Excel file for mail merge in Word?
Yes. Save the workbook, keep the recipient list in a clearly headed table, and connect it with Mailings > Select Recipients > Use an Existing List. Choose the worksheet or range that contains the records.

How do I change which people receive the merge?
Choose Mailings > Edit Recipient List. Select or clear individual recipients, or use the available sort and filter controls. Preview the changed list before choosing Finish & Merge.

Can I undo a completed mail merge?
You can close a newly created merged document without saving it, or undo recent edits while it remains open. Once a job is printed or emails are sent, Word cannot recall those copies or messages, so preview and test before completing a large merge.

Does mail merge work in Word for the web?
The full mail-merge creation and completion tools are in the desktop Word app. Open the document in desktop Word to connect recipients, insert merge fields, preview records, and finish the merge.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.