Document Editing Problems

How to Fix Microsoft Word Mail Merge Fields Not Updating

Chanuka Geekiyanage Sep 29, 2026 869 views

Question details

The user needs to resolve an issue where Mail Merge fields in Microsoft Word fail to refresh and continue displaying outdated values from the data source.

How to Fix Microsoft Word Mail Merge Fields That Do Not Update

Product: Microsoft Word
Device & OS: not provided
Scenario: Performing a mail merge operation and previewing or generating the final document.
Observed behavior: Certain merge fields remain unchanged or display old values during the merge process, even after toggling the Preview Results option.

Before you start

Ensure your Excel spreadsheet or data source file is completely saved and closed before running the mail merge in Word, as pending calculations or unsaved data will not transfer correctly.

Solution 1Recommended

Force Refresh All Mail Merge Fields

Use this method to manually force Microsoft Word to update all field codes in your primary merge document.

Sometimes Word's 'Preview Results' feature caches older data, causing the document to display incorrect values. Manually forcing a refresh of all field codes ensures that the document fetches the most recent data from your connected spreadsheet.

Select the entire document

Click anywhere inside your primary merge document and press **Ctrl+A** on your keyboard to highlight all text and fields.

Update the fields

With the entire document selected, press **F9**. This command forces Word to update all selected fields with the latest data from your data source.

Toggle Preview Results

Go to the **Mailings** tab and click **Preview Results** to verify that the fields now display the correct, updated values.

Text Box Limitation: Fields placed inside text boxes may not update using the Ctrl+A and F9 method. If possible, move your merge fields into the main body of the document or use a borderless table instead of a text box.

Solution 2

Inspect and Toggle Field Codes

Use this solution to verify that your merge fields are correctly formatted and pulling the right data.

Solution 3

Reattach the Data Source and Verify Output

Disconnecting and reconnecting the data source can resolve deeper synchronization glitches between Word and Excel.

Seamless Mail Merge in WPS Writer

Easily Create Mail Merges with WPS Office

Avoid mail merge field errors by using WPS Writer. WPS Office provides a robust, highly compatible Mail Merge feature that seamlessly integrates with your spreadsheets to generate accurate letters, envelopes, and emails without the hassle of un-updated fields.

1. Access the Mailings tab: Open your document in WPS Writer and navigate to the **Mailings** tab on the top ribbon.
2. Import your data source: Click **Open Data Source** to import your Excel spreadsheet or existing contact list.
3. Insert merge fields: Place your cursor where you want dynamic data to appear, then click **Insert Merge Field** to add the corresponding column headers.
4. Preview and merge: Click **View Merged Data** to verify your information, then select **Merge to Different New Document** to generate your final, error-free files.

Free and lightweight office suiteHighly compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsIntuitive Mail Merge wizard for error-free document generationFamiliar user interface with no steep learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why do mail merge fields inside text boxes fail to update?

Microsoft Word handles text boxes on a different drawing layer than the main document text. Because of this, the standard Ctrl+A and F9 shortcut often fails to reach fields inside text boxes. To fix this, it is highly recommended to place merge fields in the main document body or within a borderless table instead of a text box.

How do I format date and currency fields in a mail merge?

You can format dates and currencies by adding 'switches' to your field codes. Press Alt+F9 to reveal the code, then add \@ "MMMM d, yyyy" at the end of a date field (e.g., { MERGEFIELD Date \@ "MMMM d, yyyy" }) or \# "$#,##0.00" at the end of a currency field. Press Alt+F9 again and F9 to update.

Can I preview the final mail merge document before printing?

Yes. Instead of merging directly to your printer, go to the Mailings tab, click Finish & Merge, and select 'Edit Individual Documents'. This creates a brand new document containing all the merged pages, allowing you to safely review everything before printing.

Document & File Issues