Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

When you run a mail merge in Word, and if you encounter the Invalid Merge Field dialog box, it means there’s a mismatch between your data source and your main mail merge document.

For example, your mailing list was created in an Excel spreadsheet and you have under the column headers Name, Address, City, State, and Zip Code. This spreadsheet was saved and used as the data source for a mail merge in Word. After the mail merge was set up, the “State” header in the spreadsheet was changed to “Province.” When the mail merge was attempted, Word noticed this mismatch and displayed the following message.

Invalid Merge Field box

To resolve this problem from the Invalid Merge Field dialog box, you can replace the invalid field (State) with valid field from the data source (Province), or you can remove the field altogether. If you found a mistake in your data source, you can revise the field name in your data source and re-start the mail merge process.

For more information about running a mail merge, see Mail merge using an Excel spreadsheet. To learn more about mail merge fields, see Insert mail merge fields.

For an overview of mail merge, see Use mail merge to create and print letters and other documents.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×