Document Editing Problems

How to Fix Missing Mail Merge Fields in Word for iOS

Rana Garcia Oct 10, 2026 868 views

Question details

A specific field from an Excel data source is not appearing in the Insert Merge Field list in Word for iOS.

How to Fix Missing Mail Merge Fields in Word for iOS

Product: Microsoft Word for iOS
Device & OS: iOS
Scenario: Inserting merge fields into a Word document using an Excel spreadsheet as the data source.
Observed behavior: One or more fields are missing from the Insert Merge Field dropdown menu, while other values populate correctly.

Before you start

Ensure that your Excel spreadsheet is fully updated, saved, and closed before attempting to connect it to your Word document for the mail merge.

Solution 1Recommended

Verify Excel Column Headers and Reconnect Data Source

Check the Excel file for formatting issues that prevent Word from recognizing the column headers as merge fields.

Mail merge errors in Word for iOS often occur when the Excel data source contains improperly formatted column headers. Word relies on the first row of your spreadsheet to identify available merge fields.

Format Excel headers

Open your Excel data source and ensure all column headers are located in the very first row of the spreadsheet.

Remove duplicates and special characters

Verify that every column header has a unique name and does not contain special characters, hidden spaces, or line breaks.

Reconnect the data source

Save and close the Excel file. Open Word for iOS, go to the Mailings tab, and use the 'Select Recipients' option to reconnect the updated Excel file and refresh the field list.

Verify Excel Column Headers and Reconnect Data Source

Microsoft Support Investigation: If the field remains missing or an incorrect field appears, you may need to provide sanitized copies (with sensitive information removed) of the main document and data source to Microsoft Support for further investigation.

Free Microsoft Office alternative

Try WPS Office for Seamless Document Editing

If you are experiencing recurring bugs with Microsoft Word for iOS, WPS Office provides a robust, lightweight, and free alternative with excellent compatibility for Microsoft Office formats.

1. Download and Install: Get WPS Office for free from the App Store or the official WPS website.
2. Open your documents: Open your existing .docx and .xlsx files directly in WPS Office without losing any formatting.
3. Edit seamlessly: Enjoy a smooth, bug-free editing experience on your iOS device.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Reliable document formatting and robust data handling capabilities.Lightweight app that runs smoothly on iOS, Android, Windows, and Mac.Familiar user interface for a seamless transition from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why are some of my Excel columns not showing in Word's mail merge?

This usually happens if the column headers in Excel are blank, contain special characters, have duplicate names, or are not located in the first row. Word requires clean, text-based headers in row 1 to recognize them as merge fields.

How do I sanitize a document before sending it to support?

To sanitize a document, create a copy of your files and replace all sensitive or personally identifiable information (like real names, addresses, or emails) with dummy text (e.g., 'Test Name', 'test@example.com') while keeping the file structure intact.

How do I refresh my mail merge data source in Word for iOS?

To refresh the data, go to the Mailings tab and reselect 'Select Recipients' to choose your data source again. This action forces Word to pull in the latest changes and updated headers from your Excel file.

Document & File Issues