Office for Mac Issues

Fix Word Mail Merge Error: Could Not Finish Merging Documents on Mac

Steve K Oct 7, 2026 869 views

Question details

User is unable to complete a mail merge in Microsoft Word for Mac using an Excel data source, despite the database loading and previewing correctly.

How to Fix Word Mail Merge Error: Could Not Finish Merging Documents on Mac

Product: Microsoft Word
Device & OS: Mac
Scenario: Attempting to merge a document with an Excel spreadsheet containing around 900 records.
Observed behavior: The database connects and previews properly, but the actual merge process fails and throws a 'Could not finish merging documents' error, even when attempting smaller record sets.

Before you start

Make a backup copy of your original Excel data source file before modifying or deleting any rows to prevent accidental data loss.

Solution 1Recommended

Clean Up Formatting Errors in the Excel Data Source

Inspect your Excel spreadsheet for inconsistent data types, blank rows, and merged cells, which are the most common triggers for mail merge failures.

A mail merge requires a strictly formatted database. Even a single invalid record or irregularly formatted cell can cause Word to abort the entire merge process.

Remove blank rows and columns

Open your Excel data source and delete any completely empty rows or columns within your data range. Ensure there are no stray spaces or characters outside your main dataset.

Unmerge all cells

Highlight your entire spreadsheet, navigate to the 'Home' tab, and click the 'Merge & Center' button to unmerge any cells. Merged cells disrupt the database structure Word relies on.

Verify data consistency

Check that each column contains a consistent data type. For example, ensure a column meant for text doesn't contain random date formats, errors (like #DIV/0!), or invalid email address structures.

Save and retry

Save the cleaned Excel file, close it, and then reopen your Word document to attempt the mail merge again.

Pay Attention to Recent Changes: If this mail merge worked previously, focus your inspection on recently added or modified records, as they are likely the source of the formatting error.

Solution 2

Isolate the Problematic Record by Batching

If cleaning the document doesn't work, test the merge in smaller batches to pinpoint the exact row causing the failure.

WPS Office Mail Merge

Complete Your Mail Merge Smoothly with WPS Office

If Microsoft Word for Mac continues to fail, you can open your documents in WPS Office. WPS Writer includes a robust, built-in Mail Merge tool that easily connects to Excel spreadsheets and handles large datasets without crashing.

1. Open your document in WPS Writer: Launch WPS Office and open your main mail merge document (.docx).
2. Access the Mail Merge tool: Navigate to the 'References' tab on the top ribbon and click on 'Mail Merge'.
3. Connect your Excel data source: Click 'Open Data Source' and select the Excel spreadsheet containing your contact list.
4. Finish the merge: Verify your merge fields, then click 'Merge to New Document' or 'Merge to Printer' to complete the process smoothly.

Full compatibility with Microsoft Word (.docx) and Excel (.xlsx) formats.Robust Mail Merge functionality that efficiently handles large data sources.Built-in data source preview and intuitive field mapping tools.Free, lightweight, and features a familiar user interface for Mac.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the mail merge preview work but the actual merge fails?

The preview function in Word typically only loads the first few records or renders them virtually without fully processing the document structure. The actual merge processes every row; if a single row deeper in the dataset contains a critical formatting error, the entire merge will abort.

Can merged cells in my Excel file cause a mail merge error in Word?

Yes. Merged cells disrupt the strict row-and-column grid layout required by a mail merge database. This confuses the merge processor and frequently results in the 'Could not finish merging documents' error.

How do I find which record is causing the mail merge failure?

The most effective method is batch testing. In Word, select the option to merge a specific range of records (e.g., 1-50, then 51-100). Once a specific batch fails, continue narrowing down that range until you identify the exact problematic row in your Excel file.

Office App Problems