Use Excel Named Ranges as Mail Merge Recipients in Word or Publisher
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.

- 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.
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.
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.
In Excel, open the workbook and select the data range. Click Formulas > Name Manager > New.
Enter a one-word name with no spaces or special characters, confirm the Refers to box contains the correct range, and click OK.
Save the workbook as an .xlsx file and keep it closed or leave it open before connecting.
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.
Preview the mail merge or edit the recipient list to confirm the header row and the named range rows are loaded.

Troubleshoot a Named Range That Does Not Appear
Use this if the name is not listed in Word or Publisher after browsing to the workbook.
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.

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.




