Fix Word Mail Merge Stopping After Two Records on Mac
Question details
The user needs Word to process all records in a spreadsheet mail merge instead of stopping after the second record.

- Product
- Microsoft Word for Mac
- Device & OS
- macOS 10.14; Word version 16.16.4
- Scenario
- A Word mail merge uses a spreadsheet containing text fields, some empty cells, and some values that begin with a question mark.
- Observed behavior
- The first two records merge correctly, but processing stops afterward without an error message.
Identify the worksheet and rows intended for the merge, and note whether the merge stops during preview or when generating the final documents.
Check the recipient list and spreadsheet range
Use this check to rule out a limited data range, recipient filter, or missing key field.
Open the source spreadsheet and check the header row, the rows around the second and third records, and key fields for blank cells, unusual characters, or inconsistent formatting.
In Word, open the Mailings tab and choose Select Recipients to reconnect the spreadsheet. When prompted, select the worksheet or range containing all intended records.
On the Mailings tab, open Edit Recipient List and verify that records beyond the second are listed and selected. Clear any filters that exclude them.
Choose Mailings > Finish & Merge > Edit Individual Documents, select All if prompted, and check whether the resulting document includes records beyond the second.

Update Word for Mac and test a simplified data source
Use this approach if the recipient range and merge settings are correct but the merge still stops early.
Work with Word Documents and Spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats, making it easier to move existing documents and spreadsheets. It does not repair Word for Mac's mail merge behavior.

Frequently Asked Questions
Why does my merge include only the first two records?
The selected spreadsheet range, a recipient filter, or the final merge selection may limit the output. In Word, check Mailings > Edit Recipient List, reconnect the intended worksheet if needed, and choose All when finishing the merge.
Do empty spreadsheet cells always stop a Word mail merge?
No. Empty cells can be worth checking, especially in key fields, but they are not necessarily the cause. Test a simplified worksheet with populated key fields to see whether the behavior changes.
Can a question mark at the start of a field cause the merge to stop?
A leading question mark is not proven to be the cause. To test it, use a simplified copy of the source sheet and compare merge results with and without that character.
How can I check for Word updates on a Mac?
In Word, choose Help > Check for Updates and follow the prompts for any available updates. Availability depends on your Office version and macOS compatibility.




