When your Word mail merge process stalls or produces unexpected results, the issue often stems from display settings, Excel data formatting, or lingering filters rather than a corrupted software installation. If you find your document displaying raw field codes, missing recipient data, or persistent error messages, you can resolve these disruptions by methodically checking your configuration within the desktop version of Microsoft 365 on Windows 11.
Understanding Mail Merge Display Quirks
Before modifying your files, determine if the merge is truly broken or simply misconfigured. If you see text like { MERGEFIELD FirstName } instead of your data, you have accidentally enabled the field codes view. Pressing Alt + F9 will toggle this setting and return your document to its standard view. Similarly, seeing placeholders like «FirstName» is normal behavior when the preview feature is inactive; simply enable the Preview Results toggle in the Mailings tab to see your actual data.
Managing Data Source Connections
Word connects to Excel through a database query, which may trigger a security confirmation message upon opening your document. This prompt indicates that Word is reconnecting to your data source. If you receive an error stating that Word cannot find your file, the source document has likely been moved, renamed, or deleted. You can re-establish this link by navigating to the Edit Recipient List and selecting the correct file path, ideally stored in a stable location like your Documents folder.
Resolving Recipient and Field Listing Issues
If specific recipients are missing from your output, check for unchecked rows or active filters within the Edit Recipient List. A filter left over from a previous session will exclude records without warning. Furthermore, if your fields do not appear in the Insert Merge Field list, ensure that your Excel workbook has a clean header row. Blank cells, merged cells, or title rows above your headers often prevent Word from correctly identifying the available data fields.
Correcting Data Formatting and Label Layouts
Excel often strips leading zeros from ZIP codes by treating them as standard numbers. To prevent this, format the relevant columns in your Excel spreadsheet as Text before reconnecting the file to Word. For more complex formatting, such as specific date styles or decimal precision, you can apply field switches like # for numbers or @ for dates directly within the Word field code.
Label creation requires specific handling of the «Next Record» field to ensure each label displays a unique recipient. If your labels repeat the same name or skip records, verify that the first label is set up correctly and click Update Labels to propagate the logic. Manually adding or deleting these fields can cause alignment errors, so using the built-in update tool is the most reliable approach.
Fixing Bookmark Errors
The error message “Error! Bookmark not defined.” typically indicates that a cross-reference or table of contents in your main document points to a deleted or renamed bookmark. Because this error resides in the template, it propagates into every merged document. Locate and update or remove the broken reference in the original document to clear the warning from your output. Performing these troubleshooting steps in the desktop version of Word ensures you have access to the full feature set needed to resolve your Word mail merge errors.
