Printing Problems

How to Print Word Mail Merge Data and Maps on Double-Sided Half Sheets

Maira Mehtab Sep 30, 2026 868 views

Question details

The user needs to print a mail merge document featuring employee information on the front and corresponding maps on the back using two half-sheets per page, but the data is misaligning during duplex printing.

How to Print Word Mail Merge Data and Maps on Double-Sided Half Sheets

Product: Word
Device & OS: not provided
Scenario: Creating a double-sided mail merge (such as postcards or half sheets) where the back page information must match the specific recipient on the front page.
Observed behavior: The current print setup prints one employee's information on the front and the next employee's information on the back, causing the employee details and corresponding maps to misalign.

Before you start

Verify that your printer hardware supports automatic duplex (double-sided) printing and that your mail merge data source is completely updated and saved.

Solution 1Recommended

Structure Layout with Interleaved Data and Tables

Reorganize the layout using a table structure to force the correct front-to-back relationship for each recipient before printing multiple items per page.

When printing two records per page double-sided, standard mail merge settings may feed the next record to the back of the sheet instead of the bottom half of the front. Structuring your layout manually ensures the mapping remains perfectly aligned.

Set Up a Custom Table Layout

Open your Word document, go to the Insert tab, and create a 1x2 or 2x2 table that matches the dimensions of your half sheets (e.g., two postcards per page).

Insert Front Data

Navigate to the Mailings tab, click Insert Merge Field, and place the employee's text information into the top half of the layout (Page 1 in the logic).

Insert Back Data (Maps)

Move to the next section representing the back of the sheet. Insert the corresponding merge field for the map image or text.

Add the Next Record Rule

Click Rules in the Mailings tab and select <<Next Record>>. Place this rule only at the very end of the back-page data block so the system knows to pull a new employee for the next physical sheet.

Structure Layout with Interleaved Data and Tables

Layout Adjustments: You may need to manually arrange the table cell heights and margins in the Layout tab to ensure the top and bottom halves divide exactly in the center of the printed page.

Solution 2

Configure Duplex Printer Settings Correctly

Adjust your local printer properties to ensure it handles double-sided printing properly and flips on the correct edge to align the front and back layouts.

Easily Create Complex Double-Sided Mail Merges with WPS Writer

WPS Writer offers an intuitive and powerful Mail Merge feature that makes organizing tricky layouts—like double-sided half sheets and postcards—simple. It handles precise table positioning and seamlessly connects to your data spreadsheets.

1. Open WPS Writer: Launch WPS Writer and create a new document with your desired half-sheet layout using the Page Layout tab.
2. Connect Your Data: Navigate to the References tab, click Mail Merge, and select Open Data Source to link your employee and map spreadsheet.
3. Insert Fields and Rules: Click Insert Merge Field to place employee information on the front, insert the map on the back, and use Insert Next Record at the end of the set.
4. Print Double-Sided: Click Merge to Printer, check the duplex (double-sided) option in your printer properties, and print.

Fully compatible with Microsoft Word (.docx) formats and Excel data sources.Visual page layout tools to easily align front and back half-sheet designs.Built-in robust Mail Merge function with easy-to-use rule insertion.Free and lightweight office suite for seamless document creation.

Frequently Asked Questions

Why is my mail merge skipping records on the back page?

This usually happens when the <<Next Record>> rule is missing or placed incorrectly. Ensure the <<Next Record>> rule is only placed after the complete set of data for a single recipient (both front and back) is finished.

How do I print two different mail merge items on one physical page?

You can achieve this by configuring the document as a 'Labels' mail merge, which natively supports multiple records per page, or by manually structuring a table and inserting the <<Next Record>> rule between the top and bottom halves.

Can I merge images or maps dynamically in a mail merge?

Yes. You can merge dynamic images by using the IncludePicture field code combined with a merge field that references the file path of the map image corresponding to each employee in your data source.

Document & File Issues