Document Editing Problems

How to Create a Full Page of Repeated Labels for Each Name in Word

Maira Mehtab Sep 27, 2026 871 views

Question details

The user needs to generate a full page of identical labels for a single name from a data list, advancing to the next name only when a new page begins.

Product: Word / WPS Writer
Device & OS: not provided
Scenario: Creating bulk labels where each recipient requires an entire dedicated page of their own repeated labels, rather than one single label per person.
Observed behavior: By default, the mail merge function advances to the next record for every single label, which prints different names on the same page instead of repeating one name.

Before you start

Ensure your data source (such as an Excel spreadsheet) is prepared with the exact list of names you want to create labels for.

Solution 1Recommended

Modify the Next Record Fields in Mail Merge

Remove the Next Record field from all labels except the last one on the page so that the same name repeats across the entire sheet.

When you use the Update Labels feature, the word processor automatically inserts a Next Record command into every label after the first one. To repeat the same name across the whole page, you must manually delete this command from all labels except the very last one at the bottom of the page.

Create a label mail merge

Start a new label mail merge document and select your preferred label size and vendor.

Insert merge fields

Link your data source and insert your desired merge fields (like First Name and Last Name) into the first label on the page.

Update all labels

Click the 'Update Labels' button to automatically copy the merge fields to all other labels on the current page.

Remove Next Record fields

Manually delete the <<Next Record>> field from every label on the page EXCEPT the final label at the very end of the page.

Preview and merge

Click 'Preview Results' to confirm that one name fills the entire first page, and the next name begins on the second page. Finish the merge to generate your document.

Understanding the Next Record Field: The Next Record field instructs the program to move to the next row in your data source. Placing it only at the end of the page ensures the name change happens only when a new page is generated.

WPS Writer Mail Merge

Easily Create Custom Bulk Labels with WPS Office

WPS Writer offers a robust and intuitive Mail Merge feature fully compatible with Word documents and Excel data sources, making customized bulk label creation incredibly simple.

1. Access Mail Merge: Open WPS Writer, go to the 'References' tab, and click 'Mail Merge' to reveal the mailings ribbon.
2. Open Data Source: Click 'Open Data Source' to import your spreadsheet containing the list of names.
3. Insert Fields and Update: Insert your merge fields into the first label, click 'Update Labels', and then delete the <<Next Record>> tags from all but the last label.
4. Merge to New Document: Click 'Merge to New Document' to instantly generate a file with full pages of repeated labels for each person.

Free and lightweight word processor.Seamlessly import data from WPS Spreadsheet or Microsoft Excel.High compatibility with Microsoft Word documents (.docx).Customizable label layouts for efficient printing.

Frequently Asked Questions

Why are my labels printing a different name on every sticker?

This happens because the 'Next Record' rule is applied to every label by default during a standard mail merge. To repeat the same name, you must delete this field from all labels except the final one on the page.

How do I view the field codes to delete the 'Next Record' tag?

You can view the hidden mail merge tags by toggling the field codes. Press Alt + F9 on your keyboard to reveal the codes, allowing you to highlight and delete the <<Next Record>> text.

Can I use an Excel spreadsheet as my data source for labels?

Yes, you can use an Excel (.xlsx), CSV, or WPS Spreadsheet file as the data source for your mail merge. Ensure your column headers (e.g., 'Name', 'Address') are clearly labeled for easy mapping.

Document & File Issues