Show the Select Table Dialog in Word Mail Merge
Question details
The user needs Word to display the Select Table dialog when connecting an Excel recipient list to a 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.
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.
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.
In Word, select File > Options > Advanced.
Under General, select Confirm file format conversion on open, then select OK.
Start the mail merge again, then select Mailings > Select Recipients > Use an Existing List and open the Excel workbook.
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.
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.

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.

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.




