Combine Multiple Excel Rows per Person in a Word Mail Merge
Question details
Combine multiple Excel actions associated with one person into a single Word mail merge document or table.

- 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.
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.
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.
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.
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.
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.
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.

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.

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.




