Look for a Mismatch

If you open the Excel spreadsheet and review the labels in the first row, you may notice that the labels are not spelled the same as the Mail Merge Fields in the Word document.

The labels in the spreadsheet have no space between First and Name. It says: FirstName.

The Mail Merge fields in our document have an underscore: <<First_Name>>.

Match, Match, Match: It's like getting the right shoes on the right kid. The fields have to match.

graphic2
graphic3

 

Exam 77-425 Microsoft Word 2013 Expert
3.0 Create Advanced References
3.3 Manage forms, Fields, and Mail Merge Operations: Troubleshoot Mail Merge Errors

graphic1
Microsoft Excel