Document Editing Problems

Use Excel Named Ranges as Mail Merge Recipients in Word or Publisher

Bushra ParveenBushra Parveen Nov 13, 2026 868 views

Question details

The user needs to define a named range in Excel and make it available as a mail merge recipient list in Word or Publisher.

Use Excel Named Ranges as Mail Merge Recipients in Word or Publisher
Product
Microsoft Excel, Microsoft Word, and Microsoft Publisher
Device & OS
not provided
Scenario
The user is preparing a mail merge and wants to reuse a specific Excel range by its defined name instead of selecting the whole sheet or a fixed range.
Observed behavior
The named range should appear as a selectable recipient list when connecting to the Excel workbook from Word or Publisher.
Before you start

Open the Excel workbook and confirm the data range has a header row. Save the workbook as an .xlsx file after creating the name so Word or Publisher can read the defined range correctly.

Solution 1Recommended

Create a Defined Name in Excel and Select It in Word or Publisher

Use this when you want to restrict the mail merge to a specific Excel range and have that range appear as a selectable recipient list.

The defined name must follow Excel range-name rules: no spaces, no special characters, and it must refer to a valid data range with a header row.

1
Open Excel Name Manager

In Excel, open the workbook and select the data range. Click Formulas > Name Manager > New.

2
Create the named range

Enter a one-word name with no spaces or special characters, confirm the Refers to box contains the correct range, and click OK.

3
Save the workbook

Save the workbook as an .xlsx file and keep it closed or leave it open before connecting.

4
Connect from Word or Publisher

In Word or Publisher, open the Mailings tab, click Select Recipients > Use an Existing List, browse to the workbook, and choose the defined name when prompted.

5
Confirm the recipient list

Preview the mail merge or edit the recipient list to confirm the header row and the named range rows are loaded.

Create a Defined Name in Excel and Select It in Word or Publisher
Defined name available: After saving the workbook, the named range should appear as a separate list option.
Free Microsoft Office alternative

WPS Office: A Free, Lightweight Alternative for Excel Data Mail Merge

WPS Office opens .xlsx and .docx files with a familiar ribbon interface, includes WPS Spreadsheets and WPS Writer for mail merge tasks, and makes it easy to reuse Excel data without a Microsoft Office subscription.

Opens and saves Excel .xlsx and Word .docx files with high compatibility.Free, lightweight suite that replaces Word, Excel, and Publisher tasks with WPS Writer, Spreadsheets, and PDF tools.Familiar Mailings-style workflow in WPS Writer reduces the learning curve for mail merge.Seamless migration from Microsoft Office files, including workbooks with named ranges.
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my Excel named range appear in the Word recipient list?

Usually the workbook was not saved after the name was created, or the name contains spaces or special characters. Open Excel's Name Manager, correct the name, save the file as .xlsx, and then reconnect through Mailings > Select Recipients > Use an Existing List.

Can I use the same named range in Publisher mail merge?

Yes. In Publisher, open the Mailings tab, choose Select Recipients > Use an Existing List, browse to the saved Excel workbook, and select the named range when prompted, just as you would in Word.

What makes a valid Excel range name for mail merge?

The name must begin with a letter or underscore, contain no spaces or special characters, refer to a continuous data range with a header row, and be saved in the workbook before connecting from Word or Publisher.

Does WPS Office support Excel named ranges for mail merge?

WPS Office can open .xlsx workbooks, and WPS Writer provides a mail merge workflow from spreadsheet data. For exact Word or Publisher named-range recipient-list behavior, use Microsoft Office; WPS Office is a free, compatible alternative for many Office tasks.