Word mail merge not working: how to fix it

Quick answer: Start on the Mailings tab. Pick a document type with Start Mail Merge, then connect a list with Select Recipients; until both are set, most merge buttons stay unavailable. Close the Excel workbook before you connect it, keep the data on the first sheet with one header row, and format ZIP codes and percentages as text in Excel so Word doesn’t change them. If the document shows { MERGEFIELD } codes, press Alt+F9. For email, Word needs Outlook (or another MAPI-compatible mail program) installed and set up.

Applies to: Word for Microsoft 365, Word 2021, Word 2019 and Word 2016 on Windows, with an Excel workbook as the recipient list. Word for Mac and Word for the web handle mail merge differently and aren’t covered step by step.

A mail merge has three moving parts: the Word document with its merge fields, the recipient list it reads from, and the output you send to a printer, a new document or your mail program. When the merge stops working, one of those links has broken. Find what you see in the table and jump to the matching fix.

Match your symptom

What you seePossible causeGo to
Insert Merge Field, Preview Results or Finish & Merge is unavailableNo document type or no recipient list chosenFix 1
Word can’t open the workbook, or the list never loadsThe workbook is open, locked or stored onlineFix 2
The wrong data appears, or field names read F1, F2Wrong sheet, or no header rowFix 3
Prices lose decimals, dates show as numbers, ZIP codes lose zerosExcel formatting doesn’t carry into WordFix 4
You see { MERGEFIELD FirstName } instead of a nameField codes are displayedFix 5
Blank pages, missing people, or labels repeat one recordExcluded or empty rows, or Next Record rulesFix 6
Finish & Merge doesn’t send any emailMail program not set up for WordFix 7
The connection is gone when you reopen the documentThe data source link wasn’t keptFix 8

Fix 1: Choose a document type and a recipient list

Word keeps most mail merge commands switched off until it knows what you’re making and where the names come from. A document set to Normal Word Document, or one with no list attached, leaves buttons such as Insert Merge Field, Preview Results and Finish & Merge unavailable.

  1. Open the document and select the Mailings tab.
  2. Select Start Mail Merge and choose the type you need: Letters, E-mail Messages, Envelopes, Labels or Directory.
  3. Select Select Recipients > Use an Existing List, browse to your Excel workbook and open it.
  4. Choose the sheet when Word asks (see Fix 3), then select OK.

Once a list is attached, the remaining buttons on the Mailings tab become available. If they still aren’t, check that the document isn’t open in Protected View or as read-only; Word won’t let you edit merge fields in a file it treats as locked.

Fix 2: Get Word to connect to the Excel file

Microsoft’s Excel mail merge page gives two pieces of advice that head off connection trouble: keep the workbook on your own computer, and finish all edits to it before you connect it to the Word document. Word reads the file while it builds the list, so a workbook that’s still open, mid-edit or syncing gets in the way.

  1. Save and close the workbook in Excel. Check the taskbar for a second Excel window you forgot about.
  2. If the file lives in a OneDrive or SharePoint folder, copy it to a local folder such as Documents and connect to the copy.
  3. In Word, reconnect with Select Recipients > Use an Existing List.

If Word says the file is in use and you’re sure you’ve closed it, a colleague on a shared drive might have it open, or a leftover Excel process may be holding it. Our guide to an Excel file locked for editing explains how to find and release the lock.

Fix 3: Pick the right sheet and header row

According to Microsoft, all the data you want to merge should sit on the first sheet of the workbook, and the column names should match the fields you plan to insert, for example separate FirstName and LastName columns rather than one full-name column.

  1. Move the recipient data to the first sheet, starting in cell A1, with exactly one row of headers.
  2. Delete title rows, notes or merged cells above the headers. When the first row isn’t a header row, Word may label the fields F1, F2 and so on.
  3. When you reconnect, Word shows a Select Table list of sheets and named ranges. Pick the sheet that holds the data and keep First row of data contains column headers selected.

If the field names changed since you built the document, fields you inserted earlier stop matching. Reinsert them from Insert Merge Field, or use Match Fields on the Mailings tab to pair Word’s address fields with your columns.

Fix 4: Keep numbers, dates and ZIP codes intact

Word reads the value stored in each cell, not the way Excel displays it. That’s why $1,250.00 can arrive as 1250, 75% as 0.75 and a ZIP code such as 02139 as 2139. Microsoft’s page on preparing an Excel data source covers the main cases:

  • ZIP and postal codes: format the column as text, or leading zeros are dropped. Select the column, then pick Text in the Number Format box on the Home tab. Codes that already lost their zeros need to be retyped or reimported after the change.
  • Percentages: the percentage format multiplies the value by 100, so Microsoft suggests formatting those cells as text.
  • Currency and other numbers: format each column to match its category, and type the currency or percent symbol in the Word document right before or after the merge field instead of relying on the spreadsheet.
  • CSV files: import them with Data > From Text/CSV and set the ZIP code column to Text during the import, rather than opening the CSV directly.

You can also format a value inside Word with a field switch. Press Alt+F9 to show the field codes, then add a switch inside the braces:

  • { MERGEFIELD Amount \# "$#,##0.00" } shows a number as currency with two decimals.
  • { MERGEFIELD DueDate \@ "MMMM d, yyyy" } shows a date such as November 19, 2026.
  • Press Alt+F9 again, then Preview Results to check the output.

Another option keeps Excel’s own display format: in Word, go to File > Options > Advanced, select Confirm file format conversion on open under General, then reconnect the list and choose MS Excel Worksheets via DDE (*.xls) when Word asks how to open it. This older DDE method opens Excel in the background; depending on your Office version it might read only one sheet, or not be offered at all. Treat it as a fallback when switches aren’t practical, and clear the option again once you’re done so other files open normally.

Fix 5: Show merged values instead of field codes

Text such as { MERGEFIELD FirstName } means Word is showing field codes instead of their results. The merge itself is fine; only the view has changed.

  1. Press Alt+F9 to switch every field between codes and results. To toggle just one field, click in it and press Shift+F9.
  2. If you see «FirstName» rather than real names, select Preview Results on the Mailings tab.
  3. If field codes print, go to File > Options > Advanced and, under Print, clear Print field codes instead of their values.

Merge fields have to be inserted through Insert Merge Field. Typing the chevrons or braces by hand produces plain text that Word won’t fill in.

Fix 6: Fix blank, skipped or repeated records

Start with the recipient list. Microsoft’s steps use Edit Recipient List to choose who receives the mailing, so a cleared check box quietly removes a person from the output.

  1. Select Edit Recipient List and make sure every person you need is checked. Clear any active sort or filter in the same dialog.
  2. Look for empty rows in the workbook, including rows that only look empty because they hold a space or an old format. Word treats them as records and can produce blank letters or labels. Delete them in Excel and reconnect.
  3. Step through the output with Preview Results and the Next and Previous buttons to see where things go wrong.

Labels behave differently from letters. Every label after the first needs a Next Record rule so Word moves to the following row. Set up the first label, then select Update Labels on the Mailings tab to copy the layout and rule to the rest of the sheet. If every label shows the same person, check that step first.

In a letter, the opposite applies: a stray Next Record rule (look for «Next Record» or a { NEXT } field) makes Word skip people or put two on one page. Delete it unless you meant to fit several records on a page.

Fix 7: Send email merges through Outlook

Word doesn’t send email itself. Microsoft’s email merge page says you need a MAPI-compatible mail program installed, and Word hands each message to it. Microsoft adds that to use your Outlook contacts as the list, Outlook has to be your default email program and the same version as Word. Microsoft states that rule for Outlook contacts only, but making Outlook the default is still a sensible first check when an Excel-list merge won’t send.

  1. Make sure the document type is Start Mail Merge > E-mail Messages and that your list has a column with an email address for every recipient.
  2. Open Outlook and confirm it starts without errors and has your account set up. If Outlook won’t start on its own, fix that first, because Word can’t send through it either.
  3. Set Outlook as the default mail app in Windows. Our guide to changing default apps in Windows 11 shows where that setting lives.
  4. In Word, select Finish & Merge > Send E-mail Messages, choose the email column in To, type a Subject line, pick HTML or Plain text and select OK.

The new Outlook for Windows is a separate app from classic Outlook, and it doesn’t appear to act as the MAPI program Word’s merge looks for. If you’ve switched to new Outlook and nothing sends, turn the New Outlook toggle off to return to classic Outlook, make it the default, and run the merge again. In a work setup where classic Outlook isn’t available, ask your IT team before relying on email merge.

If the messages leave Word but sit in Outlook, check the Outbox; see Outlook emails stuck in the Outbox. Keep Microsoft’s limits in mind as well: each recipient gets a separate message, you can’t add CC or BCC recipients, and you can’t attach files, though you can include links.

Fix 8: Finish the merge and keep the connection

Microsoft’s last step is Finish & Merge, where you choose Print Documents or Send E-mail Messages. A third choice, Edit Individual Documents, writes every record into a new document you can check page by page before printing, which is the safer route for a large mailing.

Save the main document when you’re done. Microsoft notes that it stays connected to the data source, and when you reopen it Word asks whether to keep that connection; choose Yes. If you choose No, or the workbook has moved, the document loses its link to the list, and you need to attach it again with Select Recipients.

If Word itself crashes or the Mailings tab misbehaves in every document, an Office repair is worth a try; see how to repair Microsoft Office. For more time-savers in Word, see our MS Word tips and tricks.

Sources

How we write our guides: read our editorial policy.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *