Document Editing Problems

Fix Missing Records in a Microsoft Word Mail Merge

Anum MushtaqAnum Mushtaq Nov 14, 2026 868 views

Question details

The user needs all intended records to appear in a Word mail merge.

Fix Missing Records in a Microsoft 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.
Before you start

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.

Solution 1Recommended

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.

1
Inspect the main document

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 }.

2
Correct unnecessary fields

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.

3
Review conditional rules

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.

4
Test the merge

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 Next Record Fields and Merge Rules
Field codes and preview: On Word for Windows, press Alt+F9 again to return to the normal field display. Previewing individual recipients does not necessarily reveal how Next Record fields affect the finished output.
Free Microsoft Office alternative

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.

Work with documents and recipient spreadsheets in one office suiteOpen and edit Microsoft Word DOCX and Excel XLSX filesUse a familiar interface for an easier transition from Microsoft OfficeGet a free, lightweight office alternative
microsoft office alternative - wps office

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.