Fix Word for Mac 16.6 Mail Merge Data Source Errors
Question details
The user needs Word for Mac 16.6 to recognize an Excel workbook as a mail merge data source.

- Product
- Microsoft Word for Mac 16.6 and Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Connecting an Excel .xlsx workbook to a Word mail merge after an Office update or while using an Insider build.
- Observed behavior
- Word may no longer recognize the .xlsx workbook as a mail merge data source.
Locate the Excel workbook you want to use and confirm that its first row contains the column names for your merge fields. Check Word > About Word to confirm your version and whether you are using an Insider build.
Use an Excel 97–2003 workbook as the data source
Try an .xls copy when Word 16.6 does not recognize the original .xlsx workbook.
Open the .xlsx data source in Excel for Mac and check that the worksheet contains the records you want to merge.
Choose File > Save As, select Excel 97–2003 Workbook (.xls) as the file format, and save the copy.
Open the merge document in Word, go to Mailings > Select Recipients > Use an Existing List, and select the .xls copy. Choose the worksheet if prompted.
On the Mailings tab, select Preview Results and check that the fields display the expected records before completing the merge.

Update Office and report the data source error
Check for a fix and send Microsoft details if the problem began after an update or occurs in an Insider build.
Restore a previous working Office version
Consider this option if the merge is urgent and a working Office installation is available in a Time Machine backup.
Work with Word documents and Excel workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format compatibility makes it easy to move existing files into WPS, although it does not repair Word for Mac's data source error.

Frequently Asked Questions
Why should I try an .xls file for my mail merge?
Word for Mac 16.6 may fail to recognize an .xlsx data source after an update or in an Insider build. Saving a copy as Excel 97–2003 Workbook (.xls) in Excel provides a workaround to try.
Will saving as .xls change my original workbook?
Use File > Save As in Excel to create a separate .xls copy. The older format has different limits, so check the copy and any compatibility warnings before using it.
Where do I select the Excel data source in Word?
Open the merge document and choose Mailings > Select Recipients > Use an Existing List. Select the workbook and, if prompted, the worksheet containing your records.
What should I do if the issue started in an Office Insider build?
Use the feedback button in Word to report the build and the steps that reproduce the error. Check Help > Check for Updates, or consider restoring a previous working version if the merge is urgent.




