Fix Missing Records in a Microsoft Word Mail Merge
Question details
The user needs all intended records to appear in a Word mail merge.

- Product
- Microsoft Word mail merge
- Device & OS
- not provided
- Scenario
- The user previews recipients and then prints or creates a merged document.
- Observed behavior
- All records may appear in preview, but the printed or merged output includes only some of them.
Identify which records are missing and whether they follow a pattern, such as every other record. Note your Word version and whether the merge is for letters, labels, or another document type.
Check Next Record Fields and Merge Rules
Use this method when records appear in preview but are skipped in the finished merge.
A Next Record field advances to the next data row. It is useful between labels or other repeated items on a page, but an unnecessary field can cause records to be skipped.
Open the mail merge main document in Word. If you use Word for Windows, press Alt+F9 to display field codes and look for fields such as { NEXT }.
Delete an unnecessary { NEXT } field from the main document, or move it to the correct position. For labels, keep the Next Record fields needed to advance between labels.
Inspect the document for rules inserted through Mailings > Rules, especially Skip Record If and Next Record If. Check whether their conditions intentionally exclude or advance past records.
Choose Mailings > Finish & Merge > Edit Individual Documents, select All, and compare the resulting document with the recipient list. You can test changes in a copy of the main document.

Check Recipient Filters and Merge Output Settings
Use this method to make sure the intended recipients and record range are selected.
Work With Mail Merge Documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its format compatibility helps you move existing Office files into WPS, though it does not repair Word's mail merge settings.

Frequently Asked Questions
Why does Word skip every other mail merge record?
An extra Next Record field can advance the data source before the current recipient is fully merged. Inspect the main document for { NEXT } fields and remove any that are not needed.
Should I remove every Next Record field from a label merge?
No. Label layouts commonly need Next Record fields between labels so each label uses a different recipient. Remove or correct only fields that are unnecessary or misplaced.
Where can I check whether recipients are filtered out?
Open the main document and choose Mailings > Edit Recipient List. Review the selected recipients and any filters applied to the list.
How can I test the merge without printing?
Select Mailings > Finish & Merge > Edit Individual Documents, choose All, and inspect the resulting document against your recipient list.




