Document Editing Problems

Fix Word Mail Merge Stopping After Two Records on Mac

Huma Ashraf ChHuma Ashraf Ch Nov 20, 2026 868 views

Question details

The user needs Word to process all records in a spreadsheet mail merge instead of stopping after the second record.

Fix Word Mail Merge Stopping After Two Records on Mac
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.
Before you start

Identify the worksheet and rows intended for the merge, and note whether the merge stops during preview or when generating the final documents.

Solution 1Recommended

Check the recipient list and spreadsheet range

Use this check to rule out a limited data range, recipient filter, or missing key field.

1
Inspect the spreadsheet

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.

2
Reconnect the data source

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.

3
Check recipient selection

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.

4
Merge all records

Choose Mailings > Finish & Merge > Edit Individual Documents, select All if prompted, and check whether the resulting document includes records beyond the second.

Check the recipient list and spreadsheet range
Empty cells and question marks: Empty cells or values beginning with a question mark do not necessarily cause the problem. Test changes to the source data rather than assuming these values are invalid.
Free Microsoft Office alternative

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.

Open and edit Microsoft Word DOCX documents and Excel XLSX spreadsheetsReview and clean spreadsheet data used for mail mergesUse a familiar interface for everyday document and spreadsheet editingMove existing Office files into a lightweight, easy-to-use suite
microsoft office alternative - wps office

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.