Word Mail Merge Failing to Update Field Codes: Fix

You run a mail merge in Word, but the names, addresses, or other merged data do not update in the final document. Instead, you see the original field codes like “MERGEFIELD FirstName” or the same data repeated on every page. This problem occurs when Word does not refresh the field codes after the data source changes or when the document was created with a different version of Word. This article explains why field codes fail to update and provides step-by-step fixes to force a refresh and restore correct merged content.

Why Word Mail Merge Field Codes Do Not Update

Word mail merge relies on field codes to pull data from an external source such as an Excel spreadsheet, Outlook contacts, or a database. When you insert a merge field, Word writes a code like { MERGEFIELD FirstName } into the document. During the merge, Word replaces each code with the actual value from the data source. If the field codes do not update, one of several conditions is present:

Data Source Connection Is Broken

If the data source file has been moved, renamed, or deleted since the merge document was created, Word cannot locate the data. The field codes remain as codes because there is no data to substitute.

Field Codes Are Locked or Manually Edited

A user may have pressed Ctrl + F11 to lock a field, preventing updates. Alternatively, someone might have typed over the field code, breaking the link between the code and the data source.

Document Was Created in a Different Word Version

Mail merge documents created in an older version of Word (such as Word 2010) may not update field codes correctly when opened in Word 2021 or Word for Microsoft 365. The underlying field code syntax is the same, but the connection to the data source may be stored differently.

Steps to Force Word Mail Merge Field Codes to Update

Use the following methods in the order shown. Start with the simplest fix and progress to more thorough steps if the problem persists.

Method 1: Update All Fields Manually

1. Open the merged document
   Open the document that contains the mail merge results. This can be the main merge document or the individual documents produced by the merge.
2. Select all content
   Press Ctrl + A to select the entire document.
3. Update all fields
   Press F9. Word updates every field code in the selection. If the data source is available, the field codes are replaced with the correct merged data.
4. Check field shading
   Go to File > Options > Advanced. Under Show document content, set Field shading to Always. This highlights all field codes in gray so you can see which parts of the document are still codes versus actual data.

Method 2: Reconnect the Data Source

1. Open the main merge document
   Open the document that contains the mail merge setup, not the individual merged results.
2. Go to the Mailings tab
   Click the Mailings tab on the ribbon.
3. Select Recipients > Use an Existing List
   Click Select Recipients and choose Use an Existing List. Navigate to the data source file and select it. If the file has been moved, browse to its new location.
4. Edit Recipient List
   Click Edit Recipient List to verify that the data source is connected and that the fields are mapped correctly. If the field names do not match, click Match Fields and map the merge fields to the correct columns in the data source.
5. Run the merge again
   Click Finish & Merge and select Edit Individual Documents. In the dialog, choose All and click OK. Word creates a new merged document with updated field codes.

Method 3: Unlock and Reapply Field Codes

1. Show field codes
   Press Alt + F9 to toggle the display from field results to field codes. You see the raw { MERGEFIELD ... } codes.
2. Unlock locked fields
   Select the field code text. Press Ctrl + Shift + F11 to unlock any field that was previously locked with Ctrl + F11.
3. Delete and reinsert the merge field
   If the field code appears corrupted or contains extra characters, delete the entire field code including the curly braces. Click the Mailings tab, click Insert Merge Field, and select the correct field from the list. Word inserts a fresh field code.
4. Update the field
   With the new field code selected, press F9 to update it.

Method 4: Use the Open and Repair Feature

1. Close Word
   Close all Word documents and exit the application.
2. Open the file with repair
   Open Word. Click File > Open > Browse. Select the mail merge document. Click the Open button dropdown arrow and choose Open and Repair. Word attempts to repair any corruption in the document, including broken field code links.
3. Reconnect the data source
   After repair, follow Method 2 to reconnect the data source and run the merge again.

If Word Still Has Issues After the Main Fix

Sometimes the field codes still do not update after you apply the methods above. The following scenarios describe additional causes and their specific fixes.

“Word Cannot Open the Data Source” Error Appears

This error means Word cannot find or read the data source file. The file may be open in another program such as Excel, or the file format is not supported. Close any program that has the data source open. If the file is an Excel workbook, ensure it is saved as a .xlsx file and that the first row contains column headers. Avoid using .xlsb or .ods formats for mail merge.

Merged Document Shows the Same Data on Every Page

If every page in the merged output shows the same name or address, the field codes are updating but the data source has only one record. Open the data source and verify that it contains multiple rows. If it does, the merge may be set to a single record. Go to Mailings > Edit Recipient List and confirm that all records are selected, not just one.

Field Codes Display as “Error! Not a valid field”

This error indicates that the field code syntax is broken. The curly braces may be missing, or the field name does not match any column in the data source. Press Alt + F9 to show the field codes. Delete the entire field code including the braces. Reinsert the merge field from the Mailings tab. Update the field with F9.

Merge Fields Appear as Plain Text Like «FirstName»

Angle brackets around a field name indicate that the field code was converted to static text, usually by copying and pasting from another document. These are not live field codes and cannot be updated. Delete the angle-bracket text and insert a new merge field from the Mailings tab.

Mail Merge Field Code Update Methods Compared

Method	When to Use	Limitations
Ctrl + A then F9	Field codes are present but not showing the latest data	Requires an active data source connection
Reconnect data source	Data source was moved or renamed	Does not fix locked or corrupted field codes
Unlock and reapply field codes	Fields are locked or manually edited	Time-consuming for documents with many merge fields
Open and Repair	Document corruption is suspected	May not recover a severely damaged file

You can now force Word mail merge field codes to update by selecting all content and pressing F9, reconnecting the data source, or unlocking and reapplying individual fields. If the problem persists, use Open and Repair to fix document corruption. For future merges, keep the data source file in a fixed location and avoid editing field codes manually. As an advanced tip, press Shift + F9 to update only the selected field rather than the entire document, which is useful when troubleshooting one specific merge field at a time.