Printing Problems

How to Print Mail Merge Two Letters per Page Double-Sided in Word

Khadija Khan Sep 28, 2026 870 views

Question details

The user needs to properly format a mail merge to print two letters per page on double-sided sheets without repeating names or mixing up the front and back content.

How to Print a Mail Merge with Two Letters per Page on Double-Sided Sheets

Product: Word
Device & OS: not provided
Scenario: Setting up a mail merge document to print two distinct records on a single page while utilizing both sides of the paper (duplex printing).
Observed behavior: The printed output repeats the same name for both letters on the page or places the front and back content on the wrong sides of the printed sheet.

Before you start

Verify that your printer supports automatic duplex (double-sided) printing and ensure you have saved a backup copy of your original Excel data source before altering its layout.

Solution 1Recommended

Reorganize Data Source and Insert Next Record Field

By restructuring your Excel data and applying Word's 'Next Record' rule, you force the mail merge to pull the correct subsequent data for the second letter and the back of the page.

When placing multiple records on a single physical sheet of paper, the word processor needs explicit instructions on when to pull the next row of data. Without a 'Next Record' field, it will simply repeat the first row's data for all fields on that page.

Additionally, double-sided printing requires the data to be ordered in a specific sequence so that the front and back of the physical paper correspond correctly.

Format the Excel Data Source

Open your Excel spreadsheet. Arrange the rows so that the first two records contain the data for the front of the sheet, and the next two records contain the data for the back. Repeat this 4-record pattern throughout the document.

Insert Standard Merge Fields

Open your mail merge document in Word. Insert the required merge fields (Name, Address, etc.) for the first letter at the top of the page.

Apply the Next Record Rule

Place your cursor at the very beginning of the second letter's section on the same page. Go to the 'Mailings' tab, click on 'Rules', and select 'Next Record' from the drop-down menu.

Insert Fields for the Second Letter

Immediately after the invisible 'Next Record' tag you just placed, insert the merge fields for the second letter.

Configure Duplex Printing Settings

Go to File > Print. Under settings, select 'Print on Both Sides' (flip on long edge or short edge depending on your layout) and execute the print job.

Reorganize Data Source and Insert Next Record Field

Preview Results: Always click 'Preview Results' in the Mailings tab before printing. This allows you to verify that the names advance correctly from the first letter to the second letter on your screen.

Seamless Mail Merge with WPS Office

Easily Create and Print Mail Merges with WPS Office

WPS Office provides a highly compatible and intuitive Mail Merge feature. You can easily link spreadsheets, apply 'Next Record' rules, and precisely manage duplex printing layouts without the hassle.

1. Open Your Document in WPS Writer: Launch WPS Office and open your letter template.
2. Link Your Spreadsheet: Navigate to the 'References' tab, click 'Mail Merge', and select 'Open Data Source' to connect your Excel file.
3. Insert Fields and Rules: Click 'Insert Merge Field' for your first letter. For the second letter on the page, click 'Insert Next Record' before adding the fields again.
4. Preview and Print Double-Sided: Click 'View Merged Data' to confirm the layout is correct, then go to Menu > Print and enable double-sided printing.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsIntuitive Mail Merge interface with easy access to rules and fieldsAdvanced print preview and duplex printing controlsFree, lightweight, and fast alternative to Microsoft Office

microsoft office alternative - wps office

Frequently Asked Questions

Why does the same name appear twice on my mail merge page?

This happens because the word processor assumes the entire page is meant for a single database record. To pull the next row of data for the second letter on the same page, you must insert a 'Next Record' rule right before the merge fields of the second letter.

How do I ensure the front and back of the printed page match the correct recipients?

You need to sort your Excel data source into groups of four. Rows 1 and 2 will print on the front of the sheet, and rows 3 and 4 will print on the back. Ensure your printer's duplex setting is configured correctly (usually 'Flip on long edge' for standard portrait letters).

Where can I find the Next Record rule in Word?

Navigate to the 'Mailings' tab on the ribbon. In the 'Write & Insert Fields' group, click the 'Rules' button (indicated by a small dropdown arrow) and select 'Next Record' from the list.

Does WPS Office support the Next Record field for mail merges?

Yes. In WPS Writer, you can find the 'Insert Next Record' button directly within the Mail Merge ribbon (under the References or Mailings tab), making it incredibly easy to set up multi-record pages.

Document & File Issues