Send & Receive Issues

How to Send Multiple Records to One Person in a Single Mail Merge Email

Maira Mehtab Sep 28, 2026 869 views

Question details

The user needs to group multiple related records (such as child records A1, A2, and A3) and send them to a single recipient in one combined email, rather than generating separate emails for each individual record.

Product: Word Mail Merge
Device & OS: not provided
Scenario: Performing an email mail merge where multiple rows of data share the same recipient email address.
Observed behavior: Standard mail merge functionality generates a separate email for every single record in the data source, cluttering the recipient's inbox.

Before you start

Ensure your data source is sorted by the shared identifier (like a parent name, family ID, or email address) so that related records are grouped sequentially before beginning the merge.

Solution 1Recommended

Use a Many to One Merge Add-in

Using a specialized third-party add-in is the most reliable way to combine multiple records with a shared identifier into a single email.

Because standard Microsoft Word mail merge generates one document or email per row, grouping multiple rows into one email requires a macro or add-in. The Merge Tools Add-in offers a 'Many to One' feature specifically designed for this scenario.

Download the Merge Tools Add-in

Navigate to https://mergetoolsaddin.com/ in your web browser and download the latest version of the Merge Tools Add-in.

Install and Enable

Follow the documentation provided on the website to place the add-in file in your Word Startup folder. When you open Word, make sure to enable macros if prompted.

Verify the Shared Identifier

Open your Excel data source and confirm that there is a column (such as 'Parent Email' or 'Family ID') that contains the exact same value for the child records that need to be grouped together.

Run the Many to One Merge

Open your main mail merge document in Word, navigate to the newly added Merge Tools tab on the ribbon, and select 'Many to One'. Configure the settings to group your data by the shared identifier and execute the merge to email.

Third-Party Tools: The Merge Tools Add-in is created by a Microsoft MVP. Ensure you read the included setup documentation carefully, as the configuration requires specific formatting in your Word document.

Solution 2

Use a DATABASE Field in the Mail Merge Main Document

Use Word's built-in DATABASE field to dynamically pull multiple related child records into the parent's mail merge email.

Free Microsoft Office alternative

Looking for a Simpler Way to Manage Documents? Try WPS Office

Complex mail merges and database fields in Microsoft Word can be frustrating to set up. Switch to WPS Office for a free, lightweight, and highly compatible productivity suite that makes handling spreadsheets, documents, and standard mail merges a breeze.

1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
2. Open Your Data Source: Use WPS Spreadsheet to easily organize and format your mailing lists without compatibility issues.
3. Start Your Merge: Open WPS Writer, navigate to the References tab, and use the intuitive Mail Merge feature to send your documents.

Fully compatible with Microsoft Word and Excel file formats.Lightweight design for faster document processing and data management.Built-in mail merge capabilities with a familiar, user-friendly interface.Free to download and use with no steep learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Can standard Mail Merge send multiple rows in one email without add-ins?

By default, a standard mail merge generates one email or document per row in your data source. To combine multiple rows into one email, you must use complex field codes (like the DATABASE field), directory merges, or specialized third-party macros like the Merge Tools Add-in.

What is the shared identifier in a Many to One merge?

A shared identifier is a common piece of data in your spreadsheet—such as a parent's name, family ID, or email address—that links multiple child records together. The merge tool uses this specific column to know which rows belong grouped together in the same email.

Why do I need two separate tables for the DATABASE field method?

Using the DATABASE field method requires a primary table for the mail merge recipients (e.g., the parents) so that only one email is generated per recipient. The secondary database table is then queried by the field code to pull the corresponding multiple records (e.g., the children) into that single email.

Outlook & Email Problems