Document Editing Problems

How to Fix Word 2010 Mail Merge Excel Data Source Errors

Khadija Khan Oct 21, 2026 868 views

Question details

The user is unable to successfully connect an Excel workbook as a data source for a Word 2010 mail merge document, a problem that appeared after migrating to Windows 10.

How to Fix Word 2010 Mail Merge Excel Data Source Errors

Product: Microsoft Word 2010
Device & OS: Windows 10
Scenario: Attempting to execute a mail merge in Word using an Excel spreadsheet to populate recipient data.
Observed behavior: The Excel workbook is either not recognized as a valid data source, triggers formatting prompt errors, or opens a blank page instead of importing the data.

Before you start

Ensure that your Excel workbook is completely closed before attempting to connect it to your Word mail merge document, as having the file open can cause data source connection conflicts.

Solution 1Recommended

Reset the Mail Merge Document Type

Resetting the main document type clears out corrupted data source connections and allows you to establish a fresh link to the Excel file.

Cancel the error prompt

If an error message appears when opening the document, click Cancel to bypass it.

Change to a Normal Word Document

Navigate to the Mailings tab on the Word ribbon, click 'Start Mail Merge', and select 'Normal Word Document' from the drop-down menu.

Re-select Letters

Click 'Start Mail Merge' again, and this time select 'Letters' (or your preferred document type).

Select the Excel data source

Click 'Select Recipients', choose 'Use an Existing List', and browse your computer to select your Excel workbook data source.

Solution 2

Disable Format Conversion Confirmation

Adjusting advanced options prevents Word from unnecessarily halting the connection process to prompt for file conversion settings.

Solution 3

Verify Network Drives and File Permissions

Migrating to a new Windows 10 computer can sometimes result in broken network drive paths or insufficient file permissions, preventing Word from accessing the data source.

Seamless Mail Merge with WPS Office

Perform Mail Merge Flawlessly in WPS Writer

Skip legacy Word 2010 connectivity errors. WPS Writer offers a modern, intuitive Mail Merge feature that seamlessly integrates with Excel (.xlsx) spreadsheets without the need for complex database connection settings or OLE DB workarounds.

1. Open your document in WPS Writer: Launch WPS Writer and open your primary document or template.
2. Access the Mail Merge tab: Navigate to the 'References' or 'Mailings' tab on the top ribbon and click 'Mail Merge' to activate the toolbar.
3. Open your Data Source: Click 'Open Data Source' on the Mail Merge toolbar and select your Excel spreadsheet (.xlsx).
4. Merge to new document: Insert your desired merge fields, then click 'Merge to New Document' to automatically generate your letters.

High compatibility with Microsoft Word (.docx) and Excel (.xlsx) file formatsIntuitive and modern interface for executing mail merges quicklyFree and lightweight alternative to heavy legacy office suitesNo complex database connectivity troubleshooting required

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Word 2010 mail merge open a blank page when selecting an Excel file?

This usually happens due to a corrupted connection link, an OLE DB connection error, or a disrupted network drive path after migrating to a new OS like Windows 10. Re-selecting the document type as a 'Normal Word Document' and then changing it back to 'Letters' usually resets the connection.

What does the 'Confirm file format conversion on open' setting do?

It is an advanced Word setting that prompts you to choose a specific conversion format when opening or connecting to a non-Word file. Disabling it allows Word to automatically use the best native method (like OLE DB) to import Excel data, often fixing mail merge connection hangups.

Can I use an Excel file stored on a network drive for my mail merge?

Yes, but if the drive mapping changes or disconnects (which is common when moving to a new computer), Word will fail to locate the data source. Always ensure the network drive is connected and accessible through File Explorer before starting the mail merge.

Document & File Issues