Data fields are not matched correctly when you perform a mail merge in Microsoft Word for Mac

When you perform a mail merge in Microsoft Word for Mac, the data fields may not be matched correctly.

This issue occurs when you use a FileMaker Pro database as the data source. This issue can occur if the mail merge uses repeating fields. For example, the name field contains repeating fields such as title, first name, and last name.

To work around this issue, use the FileMaker Import Wizard to import data from FileMaker Pro into a Microsoft Excel X for Mac workbook, and then use the Excel X workbook for the mail merge. To do this, follow these steps:

1. Start Excel X, and then open a new, blank workbook.
2. On the Data menu, point to Get External Data, and then click Import from FileMaker Pro.
3. Locate the FileMaker database that you want to use, and then click Open.
4. Click the Select Field button to move the fields that you want to use to the Fields to import list.
5. Click Finish.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.