Document Editing Problems

Why Word Mail Merge Fields Show Results Instead of Field Codes

Phi Hung Vo Oct 15, 2026 871 views

Question details

The user needs to understand why mail merge fields are displaying evaluated results rather than the underlying field codes, even when the Preview Results option is disabled.

Why Word Mail Merge Fields Show Results Instead of Field Codes

Product: Word Processor
Device & OS: not provided
Scenario: Setting up a mail merge template containing conditional rules such as IF and Next Record fields.
Observed behavior: The document displays the final calculated text for the fields instead of the raw field codes, regardless of whether Preview Results is toggled on or off.

Before you start

Ensure your document is properly linked to the intended data source and that your data spreadsheet is closed before attempting to execute or edit the merge.

Solution 1Recommended

Execute the Merge to Verify Results

Because conditional fields often evaluate automatically, the most reliable way to check your logic is to execute the merge to a new document.

This behavior is completely normal in word processing software. Programs do not always reliably display or evaluate complex 'IF' or 'Next Record' fields as field codes on the template screen.

Relying solely on the 'Preview Results' button might cause confusion. Instead, completing the merge allows you to verify the actual output.

Navigate to Mailings

Go to the 'Mailings' or 'References' tab on the top ribbon of your word processor.

Select Finish & Merge

Click the 'Finish & Merge' button located at the far right of the toolbar.

Edit Individual Documents

Choose 'Edit Individual Documents' (or 'Merge to New Document') from the dropdown menu to generate the final file.

Review the Output

Scroll through the newly created document to confirm that all IF and Next Record fields calculated the correct data for each recipient.

Expected Behavior: Seeing the calculated results early does not mean your document is broken. The software simply evaluated the condition in the background.

Solution 2

Toggle Field Codes Manually

Use keyboard shortcuts or context menus to force the document to display the underlying field codes.

WPS Writer Solution

Effortlessly Manage Mail Merges with WPS Writer

WPS Writer provides an intuitive and powerful Mail Merge feature. You can easily link data sources, insert conditional rules like IF and Next Record, and generate accurate batch documents without complex formatting glitches.

1. Open Data Source: Open WPS Writer, navigate to the References tab, click 'Mail Merge', and select 'Open Data Source' to link your spreadsheet.
2. Insert Fields: Click 'Insert Merge Field' to place standard data points or select 'Rules' to insert 'If...Then...Else' conditional statements.
3. Merge to New Document: Click 'Merge to New Document' to safely execute the logic and review your final, perfectly formatted output.

Seamlessly handles complex conditional mail merge rules.Fully compatible with Microsoft Word (.docx) formats and Excel (.xlsx) data sources.User-friendly interface makes toggling field codes and previewing results straightforward.Lightweight and completely free for standard document processing needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Alt+F9 not reveal my IF field codes?

Sometimes heavily nested fields or automatically executed IF statements remain hidden. If Alt+F9 fails to reveal the code, right-click the text and select 'Toggle Field Codes'. If that still fails, executing the merge to a new document is the best way to ensure accuracy.

Can I edit the field code if it only shows the evaluated result?

Yes. You can right-click the evaluated result and select 'Edit Field' from the context menu. This will open a dialog box where you can safely modify the field properties and underlying formulas.

Is there a way to force 'Preview Results' to work for all fields?

The 'Preview Results' feature reliably works for standard data fields (like Name or Address). However, complex conditional fields like 'IF' or 'Next Record' rely on actual merge execution to step through the data. There is no built-in setting to force complex logic to preview flawlessly without completing the merge.

Document & File Issues