How to Mail Merge Custom Designed Labels in Microsoft Publisher
Question details
The user needs to place a different recipient on each label when running a mail merge with a custom-designed label template in Microsoft Publisher.

- Product
- Microsoft Publisher
- Device & OS
- not provided
- Scenario
- Setting up a custom label design and using an Excel recipient list as the data source for a mail merge.
- Observed behavior
- When previewing or printing the merge, the same recipient is duplicated on every label across the page, resulting in multiple pages with only one recipient per page instead of advancing to the next record.
Verify that your Excel data source is properly formatted with clear column headers (such as Name and Address) and contains no blank rows before importing it into your Publisher document.
Adjust Publisher Page Setup for Multiple Pages per Sheet
Publisher handles custom labels by treating the publication page size differently than Word. Setting the page size to a single label and printing multiple copies per sheet forces the records to advance.
Unlike Microsoft Word, Publisher does not use a 'Next Record' rule on a full-sheet layout. If you design a full 8.5x11 page with multiple custom labels, Publisher considers the entire page as one single record. To fix this, you must shrink your publication size to exactly one label and let the print settings tile them.
Go to the 'Page Design' tab, click 'Size', and select 'Page Setup'. Change the width and height to match the exact dimensions of a single label.
Go to the 'Mailings' tab, select your Excel recipient list, and insert your merge fields onto this single, small label canvas.
Go to 'File' and then 'Print'. Under the Settings section, change 'One page per sheet' to 'Multiple pages per sheet'. Publisher will now automatically map different recipients to each label on the printed page.

Use VBA for Advanced Custom Label Automation
If you require a complex full-page layout where the standard print tiling does not work, you can use Visual Basic for Applications (VBA) to manually loop through records.
Easily Create Mail Merge Labels with WPS Office
Microsoft Publisher's mail merge behavior can be confusing and restrictive for custom layouts because it lacks a standard 'Next Record' function. WPS Writer provides a straightforward, intuitive Mail Merge feature that works exactly like Microsoft Word. You can design custom labels on a full page and easily advance recipients without dealing with complex page setups or VBA scripting. It's a powerful, user-friendly solution for all your document automation needs.

Frequently Asked Questions
Why does Publisher put the same name on every label?
If your page setup is configured to the size of the full sheet (e.g., Letter or A4) rather than the size of a single label, Publisher treats the entire sheet as one mail merge record. To fix this, change your page setup dimensions to a single label and select 'Multiple pages per sheet' in the print menu.
Is there a 'Next Record' rule in Publisher like there is in Word?
No, Microsoft Publisher does not include the 'Next Record' rule found in Word's mail merge ribbon. Publisher handles record advancement automatically based on how you configure the print layout (Multiple pages per sheet).
Can I import my existing Excel list directly into my label design?
Yes. In Publisher, navigate to Mailings > Select Recipients > Use an Existing List. Choose your .xlsx file, and you can map the data fields directly onto your custom label text boxes.




