Office Settings & Configuration

Show the Select Table Dialog in Word Mail Merge

Rana GarciaRana Garcia Nov 14, 2026 870 views

Question details

The user needs Word to display the Select Table dialog when connecting an Excel recipient list to a mail merge.

Show the Select Table Dialog in Word Mail Merge
Product
Microsoft Word and Microsoft Excel
Device & OS
not provided
Scenario
Selecting an existing Excel workbook as the recipient list for a Word mail merge.
Observed behavior
Excel opens directly instead of Word displaying the Select Table dialog, stopping the mail merge.
Before you start

Locate the Excel workbook containing your recipient list and check which worksheet contains the data. Make sure the first row contains clear column headings for the merge fields.

Solution 1Recommended

Confirm the Excel data source format and select OLE DB

Use Word's file conversion setting to choose an OLE DB connection when attaching the Excel recipient list.

1
Open Word options

In Word, select File > Options > Advanced.

2
Enable format confirmation

Under General, select Confirm file format conversion on open, then select OK.

3
Select the recipient workbook

Start the mail merge again, then select Mailings > Select Recipients > Use an Existing List and open the Excel workbook.

4
Choose the data connection

In the Confirm Data Source dialog, select OLE DB Database Files. If it is not visible, select Show All, then choose the OLE DB connection.

5
Select the worksheet

In the Select Table dialog, choose the worksheet containing the recipients. If the first row contains column headings, select the corresponding header option, then select OK.

Confirm the Excel data source format and select OLE DB
Connection options may vary: The available data source options can depend on the installed Word version and data providers.
Free Microsoft Office alternative

Work with mail merge files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Open compatible Word and Excel files to move your work to WPS; it does not change Word's data source settings.

Use WPS Writer's mail merge tools with recipient data where availableCompatible with Microsoft Word DOCX and Excel XLSX filesFamiliar document and spreadsheet interfaces ease migrationFree, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where is the file format confirmation setting in Word?

Go to File > Options > Advanced, find the General section, and select Confirm file format conversion on open.

What if OLE DB Database Files is not listed?

In the Confirm Data Source dialog, select Show All to display additional connection options. Available options can depend on the installed data providers.

How do I choose the correct recipient worksheet?

In the Select Table dialog, select the worksheet containing your recipient records. If its first row contains column headings, select the corresponding header option before choosing OK.

Will WPS Office change the mail merge settings in Word?

No. WPS Office is an alternative for working with compatible documents and spreadsheets; use Word's File > Options settings to change Word's data source behavior.