Fix Word 2016 Freezing When Selecting an Excel Mail Merge Source
Question details
The user needs to connect an Excel worksheet as a mail merge data source without Word 2016 freezing.

- Product
- Microsoft Word 2016 and Microsoft Excel
- Device & OS
- Windows (version not provided)
- Scenario
- Selecting an Excel workbook as a mail merge recipient list in Word using a DDE connection.
- Observed behavior
- Word may stop responding when the Excel source is selected, and the data source confirmation setting may become unchecked after updates or application failures.
Locate the Excel workbook you want to use and confirm which worksheet contains the recipient list. In Word, check whether the option to confirm file format conversion on open is enabled so you can choose a connection method.
Connect the Excel mail merge source using OLE DB
Use OLE DB instead of DDE when Word freezes while opening the Excel recipient list.
In Word, go to File > Options > Advanced. Under General, select Confirm file format conversion on open, then click OK.
Open the merge document and go to Mailings > Select Recipients > Use an Existing List. Browse to the Excel workbook and click Open.
In the Confirm Data Source dialog, select OLE DB Database Files. If it is not visible, select Show All, then choose OLE DB Database Files and click OK.
In the table selection dialog, choose the worksheet containing the recipient list and click OK. Use Mailings > Edit Recipient List to check that the records appear.

Update Office and check Word hang reports
Use these checks if Word still freezes or Office has missed updates.
Use WPS Office for Documents and Mail Merge Data
WPS Office is a free, lightweight alternative with a familiar interface for working with Word documents and Excel spreadsheets. Open compatible files in WPS to help make the move from Microsoft Office straightforward; it does not repair Word's DDE connection.

Frequently Asked Questions
Why does Word 2016 freeze when I select an Excel mail merge source?
The DDE connection may be involved in the hang. Try selecting OLE DB Database Files in the Confirm Data Source dialog instead. If Word still freezes, check updates and Reliability Monitor for more information.
Where is OLE DB Database Files in the Confirm Data Source dialog?
After choosing the workbook through Mailings > Select Recipients > Use an Existing List, select Show All in the Confirm Data Source dialog to display additional connection methods, including OLE DB Database Files.
What if the Confirm Data Source dialog does not appear?
Go to File > Options > Advanced in Word. Under General, select Confirm file format conversion on open, click OK, and select the Excel workbook again.
How can I check whether Word stopped responding?
Search Windows for View reliability history, open it, and select the date of the freeze. Look for a WINWORD.EXE event, such as an AppHangB1 report.




