Document Editing Problems

How to Put Two Records on Each Page Using Word Mail Merge

Kushani Nimanthika Oct 10, 2026 870 views

Question details

The user wants to perform a mail merge that places exactly two unique records from an Excel data source onto each page without duplicating data on the same page.

Word mail merge labels with Excel fields and Update Labels

Product: Microsoft Word
Device & OS: not provided
Scenario: Creating customized documents such as flyers, certificates, or badges by pulling consecutive data entries from an Excel list into a document designed to fit two items per page.
Observed behavior: When using a standard letter merge, the same record duplicates across the entire page, or only one record appears per page instead of advancing to records 3 and 4 on the subsequent page.

Before you start

Ensure your Excel data source is well-organized with clear column headers in the first row and no empty rows interspersed between your records.

Solution 1Recommended

Use a Labels Mail Merge

Using the Labels layout rather than a standard Letter merge automatically applies the 'Next Record' rule, allowing multiple unique records to display on a single page.

The Labels mail merge feature is specifically designed to handle multiple records on a single page. By selecting a two-per-page label template, Word manages the page breaks and advances the records sequentially without duplicating them.

Start a Labels Merge

Open a blank Word document, navigate to the Mailings tab, click 'Start Mail Merge', and select 'Labels...' from the dropdown menu.

Select a Label Layout

In the Label Options dialog box, choose a vendor and product number that corresponds to a two-labels-per-page layout (such as a half-letter size template), or click 'New Label' to define custom height and width dimensions.

Connect Excel Data Source

Click 'Select Recipients' on the Mailings tab, choose 'Use an Existing List...', and browse your computer to select your prepared Excel workbook.

Insert Merge Fields

Click into the first label (top section) on the page. Use the 'Insert Merge Field' button on the Mailings tab to add your desired data fields, formatting the text layout exactly as you want it.

Update All Labels

Click the 'Update Labels' button in the Mailings tab. This replicates your layout to the second label on the page and automatically inserts the <<Next Record>> rule so the data advances correctly.

Complete the Merge

Click 'Finish & Merge' and select 'Edit Individual Documents...'. Choose 'All' to generate a new document displaying records 1 and 2 on page one, 3 and 4 on page two, and so forth.

Preview Results: Before finishing the merge, you can click the 'Preview Results' button on the Mailings tab to verify that the two records on the first page are different.

Solution 2

Use a Directory or Catalog Mail Merge

If standard label templates do not suit your layout needs, a Directory merge prints records continuously down the page without forcing page breaks after every item.

Efficient Document Creation

Perform Advanced Mail Merges Easily with WPS Writer

WPS Office offers a highly intuitive and powerful mail merge wizard that allows you to easily format labels, letters, and directories without formatting glitches. It is a seamless choice for handling large Excel datasets.

1. Launch Mail Merge: Open your template in WPS Writer, navigate to the 'References' or 'Mailings' tab, and click the 'Mail Merge' button.
2. Import Excel Data: Click 'Open Data Source', browse for your WPS Spreadsheet or Excel file, and select the specific sheet containing your records.
3. Insert Fields and Merge: Use 'Insert Merge Field' to place your data. If creating a custom layout, use the 'Insert Next Record' rule to prevent duplicates, then click 'Merge to New Document'.

Fully compatible with Microsoft Word documents (.docx) and Excel data sources (.xlsx).User-friendly Mail Merge tool for generating multiple records per page effortlessly.Lightweight and incredibly fast, even when merging thousands of records.Free to use with built-in PDF conversion to securely share your merged output.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my mail merge duplicating the exact same record on a single page?

This usually happens because the document is set as a standard 'Letters' merge rather than 'Labels'. A Letters merge repeats the same record until a forced page break occurs. Using 'Labels' automatically adds the <<Next Record>> rule to advance the data.

How do I make the 'Update Labels' button clickable?

The 'Update Labels' button is grayed out unless the document is explicitly designated as a labels document. Go to the Mailings tab, click 'Start Mail Merge', and select 'Labels...' to activate this feature.

Do I need to manually type <<Next Record>> in my Word document?

If you are using the 'Update Labels' button, Word automatically inserts the <<Next Record>> rule for you in all subsequent labels. However, if you are manually building a custom layout outside of the Labels wizard, you can insert it manually via Rules > Next Record.

Can I use an Excel file with multiple sheets as my data source?

Yes. When you connect your Excel workbook through 'Select Recipients', a prompt will appear asking you to specify exactly which sheet (e.g., Sheet1) contains the data you wish to use for the merge.

Document & File Issues