When you run a mail merge in Word, each record from your data source should appear on a separate page or section. Instead, you see the same record repeated across multiple pages, making the merge results unusable. This problem usually occurs because the Next Record rule is missing, misplaced, or because the data source contains extra blank rows or empty paragraphs that break the merge sequence. This article explains why the same record repeats and provides the exact steps to fix the merge document so each record appears only once.
Key Takeaways: Fixing a Mail Merge That Repeats the Same Record
- Mailings > Rules > Next Record: Insert this rule before every merge field except the first record to advance to the next data row.
- Mailings > Finish & Merge > Edit Individual Documents: Use this command to preview the final merged document before printing to catch repeats early.
- Remove empty paragraphs and blank rows in your data source: Extra blank lines after the last record can cause Word to repeat the final record on additional pages.
Why Word Repeats the Same Record in a Mail Merge
Word’s mail merge engine processes one record per page or section unless you insert the Next Record rule. This rule tells Word to move to the next row of data after the current record is placed. If the rule is missing, placed in the wrong location, or if the data source contains unexpected blank rows, Word will not advance to the next record. Instead, it reuses the same data row for every subsequent page.
The most common causes are:
Missing Next Record Rule
When you create a mail merge main document from scratch, Word does not automatically insert the Next Record rule. You must add it manually after the first set of merge fields. Without it, every page after the first will show the same data as the first page.
Next Record Rule Placed Before the First Record
If you insert the Next Record rule at the very beginning of the document, before the first merge field, Word skips the first data record entirely. This can cause the second record to repeat on multiple pages because the first record was never used.
Empty Paragraphs or Blank Rows in the Data Source
Excel worksheets, Access tables, or CSV files often contain blank rows at the bottom of the data range. Word treats these blank rows as empty records. When the merge reaches a blank row, it may repeat the previous record or produce blank pages. Similarly, extra empty paragraphs in the main document can push the Next Record rule out of alignment.
Steps to Fix the Mail Merge So Each Record Appears Once
Follow these steps in order. If the merge still repeats after step 1, continue through the remaining steps.
- Open the Mail Merge Main Document
In Word, open the main document that contains your merge fields. This is the file you used to start the mail merge. Do not open the merged results file. Look for the Mailings tab on the ribbon. - Insert the Next Record Rule After the First Set of Fields
Click at the end of the first record’s merge fields, right before the page break or section break that separates records. Go to Mailings > Rules > Next Record. A chevron symbol «Next Record» appears. This rule tells Word to advance to the next data row on the following page. If you have multiple merge fields on each page, place the rule after the last field of the first record. - Check That the Next Record Rule Is Not at the Very Start
Scroll to the very beginning of the document. If you see «Next Record» before any merge fields, delete it. The first record should never have a Next Record rule before it. The rule should only appear after the first record’s fields. - Remove Extra Empty Paragraphs Between Records
Switch to Home > Show/Hide ¶ to display paragraph marks. Look for blank paragraphs (empty ¶ symbols) between the end of one record and the start of the next. Delete any extra paragraph marks. Only one page break or section break should separate records. - Clean the Data Source
Open your data source file (Excel, Access, or CSV). Delete any completely blank rows at the bottom of the table. In Excel, select the rows below your last data row and press Ctrl+Shift+Down Arrow, then right-click and choose Delete. Save the file. In Word, go to Mailings > Select Recipients > Use an Existing List and re-select the cleaned file to refresh the connection. - Preview the Merge Results
Click Mailings > Preview Results. Use the arrow buttons in the Preview Results group to scroll through records. If each page shows a different record, the fix is working. If the same record still repeats, go back to step 2 and verify the placement of the Next Record rule. - Complete the Merge
When the preview shows correct results, click Mailings > Finish & Merge > Edit Individual Documents. In the dialog, choose All and click OK. Word generates a new document with one page per record. Save this file with a new name.
When the Main Fix Does Not Stop the Repeat
Word Repeats the First Record on Every Page
If the first record appears on every page and the Next Record rule is correctly placed after the first record’s fields, the data source might have a header row that Word is misreading. In the main document, click Mailings > Select Recipients > Edit Recipient List. Verify that the Header row is the first row checkbox is checked. If it is unchecked, Word treats the header as a data record and repeats it. Check the box and click OK.
The Merge Creates One Long Document With No Page Breaks
If all records appear one after another on the same page, you need to insert a page break or section break after each record. In the main document, click after the last merge field of the first record (but before the Next Record rule if you placed it there). Press Ctrl+Enter to insert a page break. Then add the Next Record rule after the page break. Repeat this structure for the second record’s fields. Use copy and paste to duplicate the first record’s layout, including the page break and Next Record rule, for each additional record.
Word Repeats the Last Record on Extra Blank Pages
This happens when the data source has blank rows at the bottom. Open the data source file, delete all completely blank rows, and save. In Word, go to Mailings > Select Recipients > Use an Existing List and re-select the cleaned file. Run the merge again. If blank pages still appear, check the main document for extra page breaks at the end and delete them.
Mail Merge Repeating Record: Manual vs Automated Insertion of Next Record
| Item | Manual Insertion of Next Record | Using the Mail Merge Wizard |
|---|---|---|
| Description | You type merge fields and insert the Next Record rule by hand | Word’s step-by-step wizard inserts the rule automatically when you choose a letter or directory layout |
| Control over placement | Full control; you decide exactly where the rule goes | Limited; the wizard places the rule based on the template it creates |
| Risk of repeating records | Higher if you forget the rule or place it incorrectly | Lower because the wizard adds the rule for you |
| Best for | Custom layouts like labels, envelopes, or complex letterhead | Simple form letters or directories where layout is standard |
After fixing the Next Record rule and cleaning the data source, your mail merge should produce one unique record per page. To prevent this problem in future merges, always use the Mail Merge Wizard for simple letters and verify the data source has no blank rows before starting. For advanced control, learn to use the Skip Record If rule under Mailings > Rules to conditionally exclude blank or unwanted records from the merge output.