Document Editing Problems

How to Mail Merge Multiple Excel Records for Each Owner in Word

Huda Qurayshi Sep 29, 2026 869 views

Question details

The user wants to generate a single mailing document per owner that consolidates multiple related items (e.g., multiple dogs) from an Excel spreadsheet into one list.

How to Mail Merge Multiple Excel Records for a Single Owner

Product: Microsoft Word / Microsoft Excel
Device & OS: not provided
Scenario: Creating grouped mailings or many-to-one mail merges where multiple spreadsheet rows need to be combined under one recipient.
Observed behavior: Standard Letter mail merges create a new page for every single row in Excel, and using NEXTIF fields often skips owners or matches records incorrectly when grouping data.

Before you start

Before beginning your mail merge, ensure your Excel data is sorted by the primary grouping column (such as Owner Name or Owner ID) so that all related records appear consecutively.

Solution 1Recommended

Use a Directory or Catalog Mail Merge

A Directory merge allows you to list multiple items on the same page continuously instead of forcing a page break after each record, making it ideal for grouped data.

By default, a standard Letter merge assumes one row of Excel data equals one printed page. A Directory (or Catalog in older versions) merge removes this restriction, allowing consecutive records to flow together.

Start a Directory Merge

Open a blank Microsoft Word document. Go to the 'Mailings' tab on the ribbon, click 'Start Mail Merge', and select 'Directory' from the dropdown menu.

Select Data Source

Click 'Select Recipients', choose 'Use an Existing List', and locate your sorted Excel spreadsheet containing the owner and item data.

Insert Merge Fields

Use 'Insert Merge Field' to place the owner's details and the related items' details on the page. Format the layout exactly as you want it to appear for a single row.

Finish and Merge

Click 'Finish & Merge' and select 'Edit Individual Documents'. Word will generate a new document with all records listed continuously. You can then manually add page breaks between different owners if needed.

Use Table Formatting: Inserting a one-row table with your merge fields can help keep the resulting directory list neat and aligned.

Solution 2

Use a Many-to-One Merge Add-in

For complex groupings where you need a separate page automatically generated for each owner, a dedicated Many-to-One add-in simplifies the process.

Easily Perform Mail Merges with WPS Office

WPS Office Writer provides a highly compatible Mail Merge feature that seamlessly connects to your WPS Spreadsheet data, allowing you to quickly generate grouped letters, directories, and labels without complex coding.

1. Open WPS Writer: Launch WPS Office and open a new or existing Writer document.
2. Access Mail Merge: Navigate to the 'References' tab (or 'Mailings' in some interface layouts) and click on 'Mail Merge'.
3. Connect Data Source: Click 'Open Data Source' and select your grouped Excel or WPS Spreadsheet file containing the owner records.
4. Insert Fields and Merge: Click 'Insert Merge Field' to place your data placeholders. Finally, select 'Merge to New Document' to generate your consolidated mailing lists.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) file formatsIntuitive Mail Merge wizard for fast document generationFree and lightweight alternative for everyday office tasksSeamless data connection between Writer and Spreadsheets

Frequently Asked Questions

Why doesn't the NEXTIF field work for grouping an unknown number of records?

The NEXTIF field tells Word to look at the next row in your data source, but it does not loop dynamically. If you only insert one NEXTIF field and an owner has three records, the third record will either be skipped or it will misalign the next owner's data. It is only effective when you know the exact maximum number of related records per owner.

Do I need to sort my Excel data before performing a directory mail merge?

Yes. For any grouping to work properly, your data must be sorted by the primary grouping field (such as Owner Name). If the data is scattered, the directory merge will list items chronologically rather than grouping related records together.

What is the difference between a Letter merge and a Directory merge?

A Letter merge treats every single row of data as an independent document, automatically inserting a section or page break after each record. A Directory (or Catalog) merge places records consecutively on the same page until it is full, making it the right choice for creating grouped lists, inventories, or rosters.

Document & File Issues