Document Editing Problems

Combine Multiple Excel Rows per Person in a Word Mail Merge

Natalie TaylorNatalie Taylor Nov 20, 2026 870 views

Question details

Combine multiple Excel actions associated with one person into a single Word mail merge document or table.

Combine Multiple Excel Rows per Person in a Word Mail Merge
Product
Microsoft Word Mail Merge and Microsoft Excel
Device & OS
not provided
Scenario
An Excel workbook contains multiple action records for the same person, and the user wants to group them in a Word merge.
Observed behavior
Standard Word Mail Merge generally treats each Excel row as a separate record rather than grouping multiple rows under one person.
Before you start

Place the source data on the first worksheet of the Excel workbook and put field names in the first row. Use field names containing only letters and numbers; they must not start with a number or exceed 40 characters.

Solution 1Recommended

Use Merge Tools Many to One in Word

Use the Merge Tools add-in to group Excel records with a common identifier into one document or table per person.

Choose a grouping field that uniquely identifies each person, such as a person ID. Each action for that person should use the same identifier.

1
Prepare the Excel data

In Excel, place each action on its own row on the first worksheet. Include a consistent person identifier and the action details in named columns, then save the workbook.

2
Open the merge template

In Word, open the document you want to use as the merge template. Install and enable the Merge Tools add-in if it is not already available.

3
Select Many to One

Open the Merge Tools tab in Word and choose Many to One. Select the Excel workbook as the data source and identify the field used to group records.

4
Set up and run the merge

Follow the add-in's instructions to place the person fields and repeating action fields in the template. Run the merge and check that each person's output contains all of their actions.

Use Merge Tools Many to One in Word
Add-in controls may vary: Merge Tools is a third-party add-in. Refer to its instructions for the template layout and controls required by your version.
Free Microsoft Office alternative

Prepare Mail Merge Documents with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and compatibility with Word and Excel formats, making it easy to move your documents and spreadsheets. The Word Merge Tools add-in is a separate solution and is not a WPS feature.

Edit Excel-compatible workbooks to organize person and action recordsOpen and edit Microsoft Word and Excel formats, including DOCX and XLSXUse a familiar interface for working with documents and spreadsheetsMove existing Office files into a lightweight, free productivity suite
QA img-9

Frequently Asked Questions

Why does Word create a separate merge record for each Excel row?

Standard Word Mail Merge generally treats each spreadsheet row as one recipient record. To group several rows for the same person, use a many-to-one tool such as Merge Tools.

Which Excel column should I use to group each person's actions?

Use a field that uniquely identifies the person, such as a person ID, and enter the same value on every action row for that person. Select that field as the grouping field in the Many to One setup.

How should I name the Excel fields for Merge Tools?

Put the field names in the first row of the first worksheet. Use only letters and numbers, start each name with a letter, and keep it to 40 characters or fewer.

Can I use the Word Merge Tools add-in in WPS Office?

The Merge Tools add-in is intended for Word. Use WPS Office to work with compatible Word and Excel files, but use Word with the add-in for the Many to One procedure described here.