Document Editing Problems

How to Perform a Many-to-One Mail Merge in Microsoft Word

Elise Williams Sep 29, 2026 877 views

Question details

The user needs to group multiple Excel records for a single person onto one page during a mail merge.

How to Perform a Many-to-One Mail Merge in Microsoft Word

Product: Microsoft Word
Device & OS: not provided
Scenario: Creating an invoice or directory-style document where one recipient has multiple related records.
Observed behavior: Word's standard directory mail merge outputs only one record per page instead of grouping multiple records for a single person.

Before you start

Ensure your Excel data source has column headers in the first row containing only alphanumeric characters, and verify if your organizational IT policies allow the installation of third-party add-ins.

Solution 1Recommended

Use the Merge Tools Add-in for Many-to-One Mail Merge

Since Word's built-in mail merge lacks native many-to-one functionality for grouping multiple records on a single page, installing a specialized third-party add-in is the most reliable solution.

The standard mail merge in Word is designed for one-to-one merges. To create documents like invoices or consolidated reports where multiple source records share common data (many-to-one), you can use the widely trusted Merge Tools Add-in.

Download the Add-in

Download the MERGE TOOLS ADD-IN.zip file from the official developer site (mergetoolsaddin.com) and extract the files to your computer.

Install the Add-in

Open the extracted folder and carefully follow the instructions in the included 'READ ME' PDF file to install the add-in in Microsoft Word.

Prepare the Main Document

Open Microsoft Word, create your template, and set your mail merge main document type strictly to 'Letters'.

Format the Excel Data Source

Open your Excel data source and ensure that field names are in the very first row. Field names must be purely alphanumeric (no symbols like @, #, or $), cannot begin with a number, and must be under 40 characters.

Execute the Many-to-One Merge

Navigate to the newly installed Merge Tools tab in Word's ribbon and use the 'Many to One' utility to group your records and generate the output documents.

Email Merge Compatibility: This add-in does not work with the 'New Outlook' (rebranded Windows Mail) because it does not support automation. Switch back to classic Outlook if you intend to send the merged documents as emails.

Free Microsoft Office alternative

Download WPS Office for Seamless Document Editing

If you are looking for a highly compatible and lightweight alternative to Microsoft Word for your daily document processing and mail merge needs, WPS Office is an excellent choice.

1. Download and Install: Visit the official WPS Office website to download and install the free suite on your device.
2. Open WPS Writer: Launch WPS Writer and navigate to the 'References' tab to access the Mail Merge tools.
3. Connect Data and Merge: Click 'Mail Merge', open your data source, insert your merge fields, and generate your documents with ease.

Free and lightweight office suite for PC and mobileFully compatible with Microsoft Word (.docx), Excel (.xlsx), and PDF formatsBuilt-in robust Mail Merge features for fast document generationFamiliar user interface ensuring zero learning curve and seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Why is my directory mail merge only putting one record per page?

Standard directory merges in Word require specific field formatting. Without advanced MERGESEQ field coding or a third-party add-in, Word does not automatically group multiple spreadsheet rows for the same recipient onto a single page.

Can I do a many-to-one mail merge in Word without add-ins?

Yes, but it requires writing complex nested IF and MERGESEQ field codes manually within your Word document. This manual method is prone to errors and harder to maintain compared to using a dedicated add-in.

What formatting rules apply to Excel data for the Merge Tools Add-in?

Your Excel field names must be located in the first row, contain only alphanumeric characters (no symbols like @, #, or $), not begin with a number, and be no longer than 40 characters including spaces.

Why aren't my mail merge emails sending through the New Outlook?

The New Outlook app does not support COM automation, which is required by Microsoft Word and third-party merge tools to generate and send automated emails. You must switch back to the classic version of Outlook to use email merge features.

Document & File Issues