Fix Word Mail Merge Repeating Every Eighth Record on Each Page
Question details
The user needs to fix a mail merge layout for name tags that fails to progress sequentially, resulting in the same record being repeated on every page.

- Product
- Word
- Device & OS
- not provided
- Scenario
- Creating a mail merge document for eight name tags per page using a data source and Next Record fields.
- Observed behavior
- The mail merge repeats the same recipient on each page (using records 8, 16, 24, etc.) instead of showing eight different sequential records per page, despite having Next Record fields present.
Ensure your data source is correctly linked and use the 'Preview Results' feature before printing to identify layout and sequencing issues without wasting paper.
Place Merge Fields Directly in the Document Body
The primary cause of this issue is placing merge fields inside text boxes, which interferes with the 'Next Record' command. Moving the fields to the document body or a table layout resolves the problem.
Text boxes exist in a different layout layer than the main document body. When mail merge fields are placed inside text boxes, the word processor's engine often fails to process sequence fields correctly, causing the 'Next Record' rule to be ignored or miscalculated.
Select and cut the existing merge fields that are currently located inside the text boxes.
Delete the empty text boxes from your name tag layout to clear the document structure.
Insert a table that matches your name tag dimensions (e.g., a 2x4 table for eight tags per page) directly into the main document body.
Paste or insert the merge fields directly into the table cells. Ensure the '<<Next Record>>' rule is placed before the merge fields on the second and all subsequent name tags on the page.
Click 'Preview Results' in the Mailings tab to verify that the records now sequence correctly across all tags and pages.

Create Flawless Name Tags with WPS Office Mail Merge
WPS Writer offers a highly intuitive Mail Merge feature that seamlessly handles name tags, labels, and mass mailings without layout glitches. It fully supports Microsoft Word documents and Excel data sources.
- 1. Open your document: Launch WPS Writer, open your layout document, and navigate to the 'Mailings' or 'References' tab.
- 2. Connect data source: Click 'Open Data Source' to connect your spreadsheet containing the name tag data.
- 3. Insert fields: Insert your merge fields directly into a table layout for your name tags using the 'Insert Merge Field' button.
- 4. Preview and merge: Use the 'Next Record' option for subsequent tags and click 'View Merged Data' to preview before completing the merge.

Frequently Asked Questions
Why is my mail merge printing the same name on a whole page of labels?
This usually happens if the '<<Next Record>>' rule is missing from the labels. You need to ensure the '<<Next Record>>' field is placed at the beginning of the second and all subsequent labels on the page so the system knows to move to the next row of data.
Can I use text boxes for mail merge labels?
It is highly recommended to avoid text boxes for mail merge labels. Text boxes exist in a separate layout layer, which often prevents the word processor from correctly reading sequence commands like Next Record. Use a table layout instead.
How do I update all labels at once in a mail merge?
If you are using the Label layout feature, you can format the first label and then click the 'Update Labels' button in the Mailings tab. This automatically copies the layout and adds the '<<Next Record>>' field to the rest of the labels on the page.
What should I do if the Next Record field is visible but not working?
Ensure the field is an actual mail merge code and not just manually typed text. If you typed out '<<Next Record>>' on your keyboard, it will not function. Delete the text and insert the proper code from the 'Rules' drop-down menu in the Mailings tab.




