Document Editing Problems

How to Fix Excel Data Missing in Word Mail Merge Fields

Steve K Oct 7, 2026 871 views

Question details

The user needs to resolve an issue where certain Excel cell data fails to populate within Word mail merge fields.

How to Fix Excel Data Missing in Word Mail Merge Fields

Product: Word / WPS Writer
Device & OS: not provided
Scenario: Executing a mail merge to import spreadsheet data into a text document.
Observed behavior: Specific inserted mail merge fields remain blank or fail to display the corresponding Excel data without any consistent pattern.

Before you start

Ensure that your source Excel spreadsheet is saved and completely closed before running the mail merge, as open files can sometimes cause data reading errors.

Solution 1Recommended

Inspect and Toggle Merge Field Codes

Reveal the underlying field codes to verify that the mail merge fields were inserted correctly and haven't been corrupted.

Sometimes fields appear correctly on the surface but are broken at the code level. Using keyboard shortcuts to reveal field codes helps identify manually typed or corrupted placeholders.

Reveal Field Codes

Press Alt+F9 on your keyboard to toggle the document view from the standard field results to the raw field codes.

Inspect the Code Format

Look closely at the missing fields. A proper mail merge field should look like { MERGEFIELD ColumnName }. If it lacks the curly brackets or has syntax errors, it will not pull data.

Reinsert Problematic Fields

If a field code is broken, delete it. Navigate to the Mailings tab, click 'Insert Merge Field', and select the correct column header from your Excel list to reinsert it properly.

Protecting Privacy: If you need to capture screenshots of your document for technical support or community forums, ensure you blur or remove all sensitive personal data first.

Solution 2

Verify Excel Source Data Formatting

Ensure the source data in your Excel spreadsheet is formatted consistently, as mixed data types can cause the word processor to skip records.

Seamless Mail Merge with WPS Office

Easily Manage Mail Merge with WPS Writer

WPS Writer provides a highly stable Mail Merge feature that seamlessly integrates with spreadsheet data, effectively preventing missing fields and formatting errors.

1. Open WPS Writer: Launch WPS Writer and navigate to the 'Mailings' tab on the top ribbon.
2. Import Data Source: Click 'Open Data Source' and select your Excel (.xlsx) or WPS Spreadsheet file to link the data.
3. Insert Merge Fields: Click the 'Insert Merge Field' button to accurately place data placeholders exactly where you need them in your document.
4. Preview and Complete: Click 'View Merged Data' to verify all fields are populated correctly, then choose 'Merge to New Document' or 'Merge to Printer'.

Smoothly imports Excel and WPS Spreadsheet data into your text documents.Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.User-friendly visual interface for inserting, previewing, and mapping merge fields.Free and lightweight alternative to resource-heavy office suites.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my mail merge fields show as codes instead of actual data?

You likely have field codes toggled on in your document settings. Simply press Alt+F9 on your keyboard to switch the view from field codes back to the actual data results.

How do I fix missing leading zeros in my mail merge zip codes?

The word processor often drops leading zeros if it reads the column strictly as numbers. To fix this, open your Excel source file, format the zip code column entirely as 'Text', re-enter the zeros, and save before running the merge again.

Can I manually type the brackets for a mail merge field?

No, manually typing standard curly brackets {} on your keyboard will not create a functioning merge field. You must use the 'Insert Merge Field' button on the Mailings ribbon, or press Ctrl+F9 to insert actual functional field brackets.

Document & File Issues