Others

How to Create Personalized Cards in Publisher Using Mail Merge

Maira Mehtab Oct 12, 2026 871 views

Question details

The user wants to generate personalized discount cards using Microsoft Publisher and an Excel data source without disrupting the multiple-cards-per-sheet layout.

How to Create Personalized Cards in Publisher Using Mail Merge

Product: Microsoft Publisher
Device & OS: not provided
Scenario: Merging a recipient list from an Excel spreadsheet into a Publisher card template to print multiple customized cards on a single sheet.
Observed behavior: The user needs to ensure that Publisher accurately prints different names on each card while preserving the multiple-cards-per-sheet print layout.

Before you start

Ensure your recipient data is properly organized in an Excel spreadsheet with clear column headers, such as 'Name' or 'Discount Code', in the first row.

Solution 1Recommended

Use the Publisher Mail Merge Wizard

Link your Publisher card template to an Excel spreadsheet to automatically generate and print personalized cards on a single sheet.

Microsoft Publisher includes a built-in Mail Merge feature that seamlessly integrates with Excel spreadsheets. This allows you to place unique data fields onto a single design and print multiple variations without having to manually duplicate the layout.

Open your publication

Launch Microsoft Publisher and open the document containing your discount card layout.

Start the Mail Merge

Navigate to the 'Mailings' tab on the top ribbon, click on 'Mail Merge', and select 'Start Mail Merge'.

Select your data source

Choose the option to use an existing list, then browse your computer to find and select the Excel spreadsheet that contains your recipient names.

Insert merge fields

Click inside the text box on your card where you want the personalized text to appear. Click 'Insert Merge Field' on the ribbon and select the appropriate column header (e.g., Name).

Preview and print

Click 'Preview Results' to verify the names appear correctly. Once confirmed, click 'Finish & Merge', then select 'Print Documents'. Publisher will automatically preserve the multiple-cards-per-sheet layout while printing the distinct names.

Layout Preservation: As long as your original Publisher file is set up with a multiple-items-per-sheet page size, the Mail Merge print settings will automatically populate the entire sheet with different merged records.

Free Microsoft Office alternative

Try WPS Office for Your Document and Mail Merge Needs

If you are looking for a highly capable and cost-effective office suite, WPS Office provides a free, lightweight, and easy-to-use alternative to Microsoft Office. You can easily perform advanced mail merges for letters, labels, and basic cards using WPS Writer's built-in tools.

1. Download WPS Office: Visit the official WPS website, download the free installation package, and install it on your computer.
2. Open WPS Writer: Launch WPS Writer and open your label or document template.
3. Use Mail Merge: Go to the 'References' tab, click 'Mail Merge', click 'Open Data Source' to select your Excel file, and insert your desired merge fields.

Free to download and lightweight on system resourcesFully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Create personalized letters and labels using the powerful Mail Merge feature in WPS WriterFamiliar tabbed interface ensures a seamless migration from other office software

microsoft office alternative - wps office

Frequently Asked Questions

Why is Publisher printing only one customized card per sheet?

This usually happens if your print layout settings have been altered. When you select 'Finish & Merge' and go to print, look at the printer settings and ensure that 'Multiple pages per sheet' or 'Multiple copies per sheet' is selected instead of 'One page per sheet'.

Can I use a CSV file instead of an Excel spreadsheet for my mail merge?

Yes, Microsoft Publisher's Mail Merge feature supports multiple data source types. When prompted to select your recipient list, you can choose a standard CSV (Comma Separated Values) file, a plain text file, or a Microsoft Access database.

How do I update the recipient list after linking it to my Publisher file?

To update your list, open and edit your original Excel spreadsheet, save it, and close Excel. Then, in Publisher, navigate to the 'Mailings' tab, click 'Edit Recipient List', and your newly added or modified data will automatically refresh.

Can I add personalized images to my cards using Publisher mail merge?

Yes. If you have a column in your Excel spreadsheet containing the exact file paths to images on your computer, you can insert a 'Picture Field' during the mail merge process in Publisher to dynamically swap images for each recipient.

Office Quick Solutions