Document Editing Problems

Fix Word Mail Merge Cannot Retrieve an Excel Recipient List

Kushani Nimanthika Oct 21, 2026 868 views

Question details

The user is unable to load an Excel recipient list into Word to complete a mail merge process.

How to Fix Word Mail Merge Cannot Retrieve an Excel Recipient List

Product: Microsoft Word and Excel
Device & OS: not provided
Scenario: Attempting to link an existing Excel workbook as the data source for a Word mail merge.
Observed behavior: After selecting the workbook and worksheet, nothing happens. The Edit Recipient List button remains disabled, the wizard repeatedly prompts for a recipient list, and DDE import fails.

Before you start

Ensure that your Excel workbook is completely closed before attempting to link it to your Word mail merge document, as an open file can sometimes block the connection.

Solution 1Recommended

Create a Clean, Simple Excel Data Source

Use this method if your current Excel file contains macros, data validation, or complex formatting that prevents Word from reading the data.

Microsoft Word often struggles to read data from Excel files that contain macros, drop-down controls, special objects, or advanced formatting. Stripping the workbook down to simple, plain text columns is the most reliable way to establish a mail merge connection.

Open a new Excel workbook

Launch Microsoft Excel and create a brand new, blank workbook.

Copy your raw data

Go to your original Excel recipient list, highlight only the rows and columns containing your contacts, and copy them.

Paste as values

Right-click in the first cell of your new workbook and select 'Paste as Values' (the clipboard icon with a 123). This removes all macros, formatting, and data validation rules.

Save as a standard XLSX

Save this new, clean file as a standard '.xlsx' workbook on your local drive.

Reconnect in Word

Open your Word mail merge document, go to the 'Mailings' tab, click 'Select Recipients', choose 'Use an Existing List', and select your newly created clean workbook.

Keep it simple: Using plain text columns with clear header rows is the best practice for ensuring seamless database connections in Word.

Solution 2

Update Microsoft Office and Recreate the Template

Outdated software or a corrupted Word template can cause mail merge wizards to loop continuously.

Seamless Mail Merge with WPS Office

Use WPS Office for a Flawless Mail Merge Experience

Avoid database connection errors by using WPS Writer and WPS Spreadsheet. WPS Office offers a seamless, built-in Mail Merge feature that easily reads spreadsheet data without complex DDE import loops.

1. Prepare Data in WPS Spreadsheet: Open WPS Spreadsheet, create your recipient list with clear column headers (like Name, Address), and save it as an .xlsx file.
2. Open WPS Writer Mail Merge: Launch WPS Writer, open your template document, and navigate to the 'References' tab. Click on 'Mail Merge' to activate the tools.
3. Import Your Data Source: Click 'Open Data Source', locate the .xlsx file you just saved, and select the specific sheet containing your contacts.
4. Insert Fields and Merge: Use 'Insert Merge Field' to place your data into the document. Click 'Merge to New Document' or 'Merge to Printer' to complete the process.

Highly compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Built-in intuitive Mail Merge wizard that rarely encounters database connection bugs.Lightweight software that runs smoothly on all major operating systems.Free to use with a familiar, user-friendly tabbed interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the 'Edit Recipient List' button grayed out in Word?

This button remains grayed out if Word fails to establish a connection with the selected data source. This typically happens if the Excel file is corrupted, contains unreadable macros, or is currently being edited in another window.

Does the file format of my Excel recipient list matter for mail merge?

Yes. It is highly recommended to use a standard .xlsx format. Formats containing macros (.xlsm) or outdated formats (.xls) can sometimes trigger compatibility or security blocks during the import process.

How can I fix DDE (Dynamic Data Exchange) import errors in Word?

DDE errors usually occur when Excel is unresponsive or the file format conversion hangs. You can bypass this by going to Word Options > Advanced > General, and unchecking 'Confirm file format conversion on open'. Then reconnect your list using the default OLE DB method.

Can data validation in Excel break a Word mail merge?

Yes, advanced data validation, drop-down lists, and form controls can prevent Word from correctly parsing the columns. Strip these out by copying your data and pasting it as values into a new workbook.

Document & File Issues