Office for Mac Issues

Fix Word for Mac Mail Merge Errors with an Excel XLSM Workbook

Steve KSteve K Nov 13, 2026 869 views

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.

Fix Word for Mac Mail Merge Errors with an Excel XLSM Workbook
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the source workbook

In Excel for Mac or WPS Spreadsheets, click File > Open or Menu > Open, select the .xlsm workbook, and enable editing if prompted.

2
Create a new workbook

Press Command+N or click File > New Workbook to open a blank workbook.

3
Copy the required worksheet

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.

4
Save the copy as .xlsx

Click File > Save As, choose Excel Workbook (.xlsx) as the format, name the file, and save it locally on your Mac.

5
Use the clean file in Word

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.

Create a standalone XLSX copy of the mail merge data
Mail merge source simplified: The new .xlsx copy contains only the data needed for the merge, which avoids the common Word for Mac mail merge errors caused by VBA content or workbook structure.
Fix it in WPS Office on Mac

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. 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. 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. 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. 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. 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.
Avoids Word for Mac mail merge errors by using a clean .xlsx recipient listOpens and converts .xlsm data without depending on VBA macrosCompatible with Word, Excel, .docx, and .xlsx file formatsFree, lightweight, and familiar Office-style ribbon on Mac
microsoft office alternative - wps office

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.