Document Editing Problems

Use an Excel Named Range for a Word Mail Merge

Tauseeq MagsiTauseeq Magsi Nov 13, 2026 868 views

Question details

The user wants to use an Excel named range as the recipient data source for a Word mail merge.

Use an Excel Named Range as a Word Mail Merge Data Source
Product
Microsoft Word and Microsoft Excel
Device & OS
not provided
Scenario
A Word mail merge should use only the records and columns defined by an Excel named range.
Observed behavior
The default Excel connection may show worksheets rather than the named range.
Before you start

In Excel, check the range under Formulas > Name Manager and make sure it includes the column headers and desired records. Save the workbook before connecting it to Word.

Solution 1Recommended

Connect to the Excel named range through OLE DB

Use the OLE DB connection method when Word's default connection lists worksheets but not the named range.

1
Enable connection confirmation

In Word, open File > Options > Advanced. Under General, select Confirm file format conversion on open, then click OK.

2
Select the workbook

Open the merge document, go to Mailings > Select Recipients > Use an Existing List, and select the saved Excel workbook.

3
Choose the OLE DB method

In the Confirm Data Source dialog, select Show all if necessary, choose OLE DB Database Files, and click OK. The available connection options can vary by Word version and installed providers.

4
Select the named range

In the table or data source selection dialog, select the required named range and confirm the selection. If prompted, indicate that the first row contains column headers.

5
Check the recipients

On the Mailings tab, open Edit Recipient List and verify the records. Use Insert Merge Field to check that the expected columns are available.

Connect to the Excel named range through OLE DB
Range boundaries matter: Only records and columns within the selected named range are used. If the range needs to include more data, update it in Excel and reconnect or refresh the data source in Word.
Free Microsoft Office alternative

Work with Mail Merge Documents in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working on documents and spreadsheets. Open existing Office files to make the transition easier; it does not change Word's OLE DB connection options.

Use WPS Writer and spreadsheets for document and recipient-list workflowsCompatible with Microsoft Word DOCX and Excel XLSX filesFamiliar editing interface for an easier move from Microsoft OfficeFree, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Word show worksheets instead of my named range?

The default Excel connection may list worksheets. Enable File > Options > Advanced > General > Confirm file format conversion on open, reconnect the workbook, and choose OLE DB Database Files if it is available.

How do I check which cells are in my named range?

In Excel, open Formulas > Name Manager, select the name, and check its reference. Include the headers and all recipient rows you want to merge.

Will new rows outside the named range appear in the merge?

No. Update the named range in Excel to include those rows, save the workbook, and reconnect or refresh the data source in Word.

What if the OLE DB Database Files option is missing?

Select Show all in the Confirm Data Source dialog if it is available. Connection options depend on the Word version and installed providers, so the named-range method may not be available in every installation.