Office for Mac Issues

Fix Word for Mac 16.6 Mail Merge Data Source Errors

Adam DavisAdam Davis Nov 22, 2026 868 views

Question details

The user needs Word for Mac 16.6 to recognize an Excel workbook as a mail merge data source.

Fix Mail Merge Data Source Errors in Word for Mac 16.6
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the workbook

Open the .xlsx data source in Excel for Mac and check that the worksheet contains the records you want to merge.

2
Save an .xls copy

Choose File > Save As, select Excel 97–2003 Workbook (.xls) as the file format, and save the copy.

3
Connect the copy in Word

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.

4
Preview the merge

On the Mailings tab, select Preview Results and check that the fields display the expected records before completing the merge.

Use an Excel 97–2003 workbook as the data source
Check the converted workbook: The older .xls format has different size and feature limits. Review any compatibility warnings in Excel and verify that the required records and columns are present.
Free Microsoft Office alternative

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.

Open and edit Word documents and Excel workbooks in one suiteCompatible with common Microsoft Office formats, including .docx and .xlsxUse a familiar interface to ease the transition from Microsoft OfficeFree and lightweight for everyday document and spreadsheet tasks
microsoft office alternative - wps office

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.