Fix Word for Mac Mail Merge Errors with an Excel XLSM Workbook
Question details
The user needs to resolve Word for Mac mail merge errors that occur when selecting a macro-enabled Excel workbook (.xlsm) as the recipient data source.

- Product
- Microsoft Word for Mac and Microsoft Excel .xlsm workbook
- Device & OS
- macOS
- Scenario
- The user is setting up a mail merge in Word for Mac and wants to use an existing macro-enabled Excel workbook as the recipient list.
- Observed behavior
- Word for Mac errors or fails to connect when the .xlsm workbook is selected as the mail merge data source.
Open the .xlsm workbook in Excel for Mac or WPS Spreadsheets and identify the exact worksheet and table that contains the recipient data. Make sure the data has a single header row and no blank header cells.
Create a standalone XLSX copy of the mail merge data
Use this when Word for Mac cannot connect to the original macro-enabled workbook; a clean .xlsx removes VBA and extra workbook structure from the data source.
A macro-enabled workbook can carry VBA projects, hidden sheets, links, or workbook protection that Word for Mac does not handle well during a mail merge. Copying only the required sheet or table into a new .xlsx file gives Word a simple, flat data source.
In Excel for Mac or WPS Spreadsheets, click File > Open or Menu > Open, select the .xlsm workbook, and enable editing if prompted.
Press Command+N or click File > New Workbook to open a blank workbook.
Right-click the worksheet tab that contains the recipient table, choose Move or Copy, select the new workbook under To book, check Create a copy, and click OK.
Click File > Save As, choose Excel Workbook (.xlsx) as the format, name the file, and save it locally on your Mac.
In Word for Mac, go to Mailings > Select Recipients > Use an Existing List, choose the new .xlsx file, and select the correct worksheet or table.

Test the clean XLSX in Word to confirm the cause
Use this after creating the .xlsx copy; if the merge now works, the original issue is tied to the macro-enabled workbook rather than your document.
Use WPS Office on Mac to Build a Clean XLSX Data Source and Run Mail Merge
Open the macro-enabled workbook in WPS Spreadsheets, copy only the required table to a new workbook, save it as .xlsx, and then run the mail merge from WPS Writer without the Word for Mac macro-workbook error.
- 1. Open the XLSM workbook in WPS Spreadsheets: Launch WPS Office on Mac, click Menu > Open, select the macro-enabled workbook, and enable editing if prompted.
- 2. Copy the mail merge sheet to a new workbook: Right-click the sheet tab that contains the recipient table, choose Move or Copy, select New Workbook, check Create a copy, and click OK.
- 3. Save the new file as .xlsx: Click Menu > Save As, choose Excel Workbook (*.xlsx) from the format list, name the file, and save it to a local folder.
- 4. Start mail merge in WPS Writer: Open WPS Writer, click the Mailings tab, click Mail Merge, and choose the document type you want to create.
- 5. Connect the clean XLSX list and finish: Select Use an Existing List or Add Recipient, choose the .xlsx file, confirm the sheet or table, insert merge fields, and click Merge to complete.

Frequently Asked Questions
Why does Word for Mac fail to use an .xlsm file for mail merge?
A macro-enabled workbook can contain VBA projects, hidden sheets, links, or workbook structure that Word for Mac does not handle well as a mail merge data source. Using a clean .xlsx copy with only the required table usually fixes the error.
Can WPS Office open Excel .xlsm files on Mac?
Yes, WPS Spreadsheets can open .xlsm files for data access, but VBA macros may not run. For mail merge, open the workbook in WPS Spreadsheets and save the required sheet as an .xlsx file.
How do I copy one worksheet to a new workbook in Excel for Mac or WPS Spreadsheets?
Right-click the worksheet tab, choose Move or Copy, select New Workbook as the destination, check Create a copy, and click OK.
Will saving the recipient data as .xlsx remove the macros?
Yes, the standard .xlsx format does not store VBA macro modules. This makes the file a simpler and safer mail merge data source for Word or WPS Writer.
Can I run the mail merge directly in WPS Writer instead of Word for Mac?
Yes. Open WPS Writer, click Mailings > Mail Merge, choose the document type, select the clean .xlsx recipient list, insert merge fields, and complete the merge.




