Document Editing Problems

How to Mail Merge Custom Designed Labels in Microsoft Publisher

Emma BrownEmma Brown Oct 22, 2026 870 views

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.

How to Mail Merge Designed Labels 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.
Before you start

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.

Solution 1Recommended

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.

1
Resize the Publication

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.

2
Insert Merge Fields

Go to the 'Mailings' tab, select your Excel recipient list, and insert your merge fields onto this single, small label canvas.

3
Modify Print Settings

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.

Adjust Publisher Page Setup for Multiple Pages per Sheet
Previewing the Output: You will only see the correct multi-recipient layout in the Print Preview screen, not in the standard editing view.
Free Microsoft Office alternative

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.

Intuitive Mail Merge wizard makes custom label creation fast and simple.Built-in 'Next Record' functionality prevents single-recipient duplication.Seamlessly compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Free, lightweight, and features a familiar user interface.
microsoft office alternative - wps office

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.