Document Editing Problems

How to Create Grouped Word Mail Merges from Multiple Excel Rows

Natalie Taylor Sep 25, 2026 870 views

Question details

The user needs to group approximately 140 Excel rows into about 45 Word documents based on a Partner Number Range, combining values from multiple rows into shared fields.

How to Create Grouped Word Mail Merges from Multiple Excel Rows

Product: Microsoft Word / Microsoft Excel
Device & OS: not provided
Scenario: Creating a mail merge where multiple related Excel records must be consolidated into a single Word document instead of generating a separate document for every row.
Observed behavior: Standard Word mail merge creates one document per row and does not automatically group related rows by numerical ranges.

Before you start

Ensure your Excel dataset has clear column headers in the first row without special characters. Back up your original Excel workbook before applying any data grouping formulas or transformations.

Solution 1Recommended

Pre-Group Excel Data Using Power Query Before Merging

The most reliable method is to organize the Excel data into one row per group using Power Query before initiating the Word mail merge.

Since Word's native mail merge cannot group data automatically, transforming your dataset in Excel first ensures the mail merge runs smoothly without complex field codes.

Open Power Query

Open your Excel dataset, select your data range, navigate to the 'Data' tab, and click 'From Table/Range' to launch the Power Query Editor.

Group Data by Partner Range

In Power Query, select the Partner Number Range column and click the 'Group By' feature on the Home tab to consolidate related rows into a single row.

Concatenate Shared Fields

Adjust the grouping operation to extract or concatenate the required shared fields (e.g., using Text.Combine for text values), then click 'Close & Load' to output the grouped data into a new worksheet.

Execute Mail Merge in Word

Open Word, go to the 'Mailings' tab, click 'Start Mail Merge', and select 'Use an Existing List'. Choose the newly created worksheet with the grouped data to generate your final documents.

Pre-Group Excel Data Using Power Query Before Merging

Data Preparation: By formatting your data so that there is exactly one row per intended document, standard Mail Merge will work flawlessly.

Solution 2

Use the Word DATABASE Field for Grouped Records

Use a standard letter mail merge combined with a specialized DATABASE field to retrieve related records for each unique partner range.

Solution 3

Apply a Many-to-One Mail Merge Utility

Utilize a specialized third-party add-in, such as the Merge Tools Add-in, designed specifically to bypass Word's grouping limitations.

How to Perform Grouped Mail Merges in WPS Office

You can easily prepare grouped data in WPS Spreadsheets using lookup formulas or Pivot Tables, and then run a seamless Mail Merge in WPS Writer to generate your final bundled documents.

1. Group Data in WPS Spreadsheets: Open your dataset in WPS Spreadsheets. Use Pivot Tables or functions like TEXTJOIN to consolidate the 140 rows into a new sheet containing one row per Partner Number Range.
2. Start Mail Merge in WPS Writer: Open WPS Writer, go to the 'References' tab on the top ribbon, and click 'Mail Merge' to activate the merge tools.
3. Connect the Prepared Data: Click 'Open Data Source' and select your prepared WPS Spreadsheet containing the uniquely grouped rows.
4. Insert Fields and Merge: Click 'Insert Merge Field' to place your consolidated fields into the document, then click 'Merge to New Document' to generate your final grouped files.

Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) formatsAll-in-one tabbed interface for seamless switching between spreadsheets and documentsFree and intuitive built-in Mail Merge functionalityAdvanced data filtering and formulas for easy dataset grouping

microsoft office alternative - wps office

Frequently Asked Questions

Why does Word create a separate document for every Excel row?

By default, standard Word Mail Merge processes one document or page per row in your Excel data source. It does not possess a native feature to automatically group multiple rows into a single document based on a common value.

Can I use standard Excel formulas to group my data for mail merge?

Yes. You can use Excel functions such as TEXTJOIN in combination with UNIQUE or FILTER to consolidate multiple rows into a single row per group. Once your data is formatted to have one row per document, standard mail merge will work perfectly.

What is a Many-to-One mail merge?

A Many-to-One mail merge is an operation where multiple records (rows) from a database or spreadsheet are pulled into a single document based on a common key field. Because Word does not support this natively out-of-the-box, it typically requires data transformation beforehand, specialized field codes, or third-party add-ins.

Document & File Issues