Use an Excel Named Range for a Word Mail Merge
Question details
The user wants to use an Excel named range as the recipient data source for a Word mail merge.

- 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.
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.
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.
In Word, open File > Options > Advanced. Under General, select Confirm file format conversion on open, then click OK.
Open the merge document, go to Mailings > Select Recipients > Use an Existing List, and select the saved Excel workbook.
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.
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.
On the Mailings tab, open Edit Recipient List and verify the records. Use Insert Merge Field to check that the expected columns are available.

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.

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.




