Document Editing Problems

Mail Merge in Word from an Excel Workbook with Multiple Worksheets

Anum MushtaqAnum Mushtaq Nov 20, 2026 868 views

Question details

Create a mail merge using information stored across multiple worksheets in an Excel workbook.

Mail Merge in Word from an Excel Workbook with Multiple Worksheets
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a master sheet

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.

2
Combine recipient data

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.

3
Check and save the source

Review the Master sheet for missing matches, duplicate recipients, and blank headers. Keep one recipient per row, then select File > Save.

4
Connect Word to the master sheet

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.

5
Insert fields and finish

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.

Advanced alternative: A DATABASE field can retrieve related information from other worksheets, but it requires a suitable field and query setup. A master sheet is generally simpler to maintain.
Merge documents with WPS Office

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. 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. 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. 3. Save and open the document: Select File > Save in WPS Spreadsheet, then open the merge document in WPS Writer.
  4. 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. 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.
Bring recipient fields from multiple worksheets into one merge sourceWork with Microsoft Excel XLSX workbooks and Word DOCX documentsPreview recipient data before completing the mergeUse a familiar interface for spreadsheet and document editing
microsoft office alternative - wps office

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.