Mail Merge in Word from an Excel Workbook with Multiple Worksheets
Question details
Create a mail merge using information stored across multiple worksheets in an Excel workbook.

- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A Word mail merge document needs recipient information held on several worksheets in one Excel workbook.
- Observed behavior
- A standard Word mail merge selects one worksheet or data source at a time.
Check whether the worksheets contain separate recipient lists or related fields for the same recipients. For related fields, identify a shared key, such as a unique customer ID, that can be used to match rows.
Combine the Worksheets into a Master Sheet for Word Mail Merge
Use one master worksheet to provide Word with all recipient rows and fields needed for the merge.
Open the workbook in Excel and select the plus button beside the sheet tabs to add a worksheet. Name it Master and add a unique header for each merge field in the first row.
If sheets contain separate recipient lists with the same fields, copy their rows under the matching Master headers. If sheets contain related fields, use a shared ID to match and bring those fields into the correct recipient rows, for example with Excel's XLOOKUP function.
Review the Master sheet for missing matches, duplicate recipients, and blank headers. Keep one recipient per row, then select File > Save.
Open the merge document in Word and select Mailings > Select Recipients > Use an Existing List. Choose the saved workbook, select the Master worksheet, and confirm that the first row contains headers when prompted.
Use Mailings > Insert Merge Field to add the required fields. Select Preview Results to check recipients, then choose Finish & Merge to create or print the merged documents.
Create a Mail Merge from a Master Sheet in WPS Office
Combine worksheet data in WPS Spreadsheet, then connect the master sheet to a mail merge document in WPS Writer.
- 1. Open the workbook: Open the Excel workbook in WPS Spreadsheet and add a worksheet named Master using the plus button beside the sheet tabs.
- 2. Build the master data: Enter field names in the first row. Copy recipient rows from separate lists, or match related fields to recipients using a shared ID, keeping one recipient per row.
- 3. Save and open the document: Select File > Save in WPS Spreadsheet, then open the merge document in WPS Writer.
- 4. Connect the data source: In WPS Writer, open the Mailings tab and select Open Data Source. Choose the saved workbook and its Master worksheet.
- 5. Complete the merge: Use Insert Merge Field on the Mailings tab to add fields, preview the merged data, and select a merge option to create or print the documents.

Frequently Asked Questions
Can Word select several Excel worksheets for one standard mail merge?
A standard mail merge selects one worksheet or data source at a time. Combine the required data in a master worksheet, then select it through Mailings > Select Recipients > Use an Existing List.
How do I combine worksheets that contain different fields for the same people?
Use a shared unique ID to match each person's records. In Excel, you can use XLOOKUP to bring fields from another sheet into the corresponding row on the master sheet.
What if the worksheets contain separate recipient lists?
Create matching column headers on the master sheet, then copy the recipient rows from each list beneath the appropriate headers. Check for duplicate recipients before connecting the sheet to Word.
Why are some merge fields missing in Word?
Check that each required field has a unique header in the first row of the selected master worksheet. Save the workbook, then reconnect it through Mailings > Select Recipients > Use an Existing List.




