Fix Excel Opening in a New Window During Word Mail Merge
Question details
The user needs to prevent their Excel data source from opening in a separate window when configuring a mail merge in Word.
- Product
- Microsoft Word / Excel
- Device & OS
- not provided
- Scenario
- Setting up a mail merge in Word and connecting an existing Excel workbook as the recipient list.
- Observed behavior
- Instead of automatically showing the table selection dialog, Word opens the Excel workbook in a new window due to incorrect connection or file conversion settings.
Ensure that your Excel workbook is fully saved and closed before attempting to connect it as a data source in Word.
Disable File Format Conversion Confirmation
Turning off the conversion confirmation allows Word to automatically use the default OLE DB connection method without opening the Excel file.
By default, Word connects to Excel files using the OLE DB connection method in the background. If the option to confirm file format conversions is enabled, Word may pause the connection and force Excel to open in a new window instead of directly reading the data.
In Word, click on 'File' in the top-left corner, select 'Options', and then click on 'Advanced' in the left pane.
Scroll down to the 'General' section and uncheck the box labeled 'Confirm file format conversion on open'.
Go to the 'Mailings' tab, click 'Select Recipients', and choose 'Use an Existing List'. Select your Excel workbook again.
Manually Select OLE DB Database Files
If you prefer to keep the conversion confirmation enabled, you can manually choose the correct background connection method.
Easily Connect Excel Data Using WPS Writer
Avoid complex OLE DB settings and connection dialogs. WPS Writer seamlessly integrates with your spreadsheet data sources, allowing you to perform quick, error-free mail merges without unexpected pop-ups.
- 1. Open Mail Merge: Launch your document in WPS Writer and navigate to the 'Mailings' or 'References' tab on the ribbon.
- 2. Select Data Source: Click on 'Open Data Source' and browse your computer to select your Excel (.xlsx) file.
- 3. Insert Merge Fields: Place your cursor where you need the data, click 'Insert Merge Field', and select the corresponding column headers from your spreadsheet.
- 4. Complete the Merge: Click 'Merge to New Document' or 'Merge to Printer' to finalize the process effortlessly.
Frequently Asked Questions
Why does Word open Excel when I try to do a mail merge?
This happens when Word is forced to use an older connection method, such as DDE, instead of the default OLE DB. It often occurs because the 'Confirm file format conversion on open' option is enabled, causing Word to prompt for manual connection rules instead of processing it in the background.
What is the OLE DB Database Files connection method in Word?
OLE DB is the default and recommended background connection method Word uses to communicate with Excel data sources during a mail merge. It reads the data directly from the file without needing to launch the Excel application window.
Will disabling the file conversion confirmation affect my other Word documents?
No. Disabling the 'Confirm file format conversion on open' setting simply stops Word from prompting you to manually choose a file converter when opening external data sources or non-native files. Word will seamlessly rely on its best default method instead.
