Document Editing Problems

How to Create a Word Mail Merge with Multiple Excel Assets per Employee

Maira Mehtab Sep 21, 2026 868 views

Question details

The user needs to automatically generate a Word mail merge that groups multiple Excel assets for each unique employee into a single table and sends individual emails to each employee.

Product: Microsoft Word
Device & OS: not provided
Scenario: Performing a mail merge where a single email recipient has multiple associated asset records in the Excel data source.
Observed behavior: Standard Word mail merge processes each row individually, creating separate emails for each asset rather than grouping an employee's assets into a single email.

Before you start

Ensure your Excel data source has field names in the first row containing only alphanumeric characters, not starting with a number, and under 40 characters in length. Also, switch to the classic Outlook application if you are sending emails, as the new Outlook is not supported.

Solution 1Recommended

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

Because the default Word mail merge creates a new document for every Excel row, you must use a third-party add-in to group multiple assets for a single employee.

The standard Microsoft Word mail merge feature does not natively support many-to-one merges. To achieve this, you can utilize the Merge Tools Add-in.

This add-in allows you to group multiple Excel rows under a single unique employee value, insert them into a table, and send individual emails.

Prepare your Excel data source

Ensure your Excel field names are in the very first row. The column headers must contain only alphanumeric characters, cannot begin with a number, and must not exceed 40 characters in length.

Download the Merge Tools Add-in

Visit mergetoolsaddin.com and download the Many to One facility add-in to your computer.

Set up the main Word document

Open Microsoft Word and create your main document. Make sure it is configured as a Letters document type.

Switch to Classic Outlook

If you are sending the merged documents via email, open the classic Outlook desktop application. The add-in does not support the 'new' Outlook interface.

Execute the Many-to-One merge

Run the Merge Tools Add-in from Word, select your prepared Excel worksheet as the data source, configure the email merge settings, and execute the process to generate and send the grouped emails.

Outlook Compatibility: The Merge Tools add-in requires the classic Outlook application for sending email messages and will fail if the new Outlook is active.

Free Microsoft Office alternative

Need a Faster, Lighter Office Suite? Try WPS Office

If managing complex add-ins and legacy software versions in Microsoft Office feels overwhelming, consider switching to WPS Office. It provides a highly compatible, free alternative for handling your documents and spreadsheets seamlessly.

1. Download WPS Office: Visit the official WPS website and download the free installation package.
2. Install the software: Run the lightweight installer to quickly set up the office suite on your computer.
3. Open your documents: Open your existing Word and Excel files directly in WPS Office with seamless format compatibility.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Streamlined mail merge tools for standard document processing without heavy add-ins.Lightweight architecture that runs smoothly on Windows, Mac, and Linux.Free, intuitive interface that is familiar to classic Office users.

microsoft office alternative - wps office

Frequently Asked Questions

Why does standard Word mail merge create duplicate emails for employees with multiple assets?

Standard mail merge processes each row in your Excel data source individually. To group multiple rows into a single table for one recipient, you must use a many-to-one merge solution.

Can I use the new Outlook application for this email merge?

No, the Merge Tools Add-in requires the classic Outlook desktop application to successfully send the merged emails. It does not support the new Outlook.

What are the requirements for Excel column headers in the Merge Tools Add-in?

Excel field names must be placed in the first row, contain only alphanumeric characters, not begin with a number, and be no longer than 40 characters.

What document type should I use in Word for a many-to-one merge?

When setting up the many-to-one merge using the add-in, your main document must be configured as a 'Letters' document type.

Document & File Issues