Document Editing Problems

Fix Word Mail Merge Excel Recipient List Not Populating

Anum Mushtaq Oct 15, 2026 870 views

Question details

Users experience an issue where an Excel recipient list fails to populate, appears blank, or behaves inconsistently when attempting to execute a mail merge in Word.

Fix Word Mail Merge Recipient List Not Populating from Excel

Product: Microsoft Word
Device & OS: not provided
Scenario: Setting up a mail merge document for bulk emails using an existing Excel spreadsheet as the recipient list.
Observed behavior: The recipient list does not populate into the Word document fields correctly, even though the records might be visible in the Edit Recipient List dialog, preventing the bulk email from sending.

Before you start

Ensure your Excel spreadsheet has clear column headers in the very first row and contains no blank rows or merged cells before the data begins.

Solution 1Recommended

Reconnect to a Clean, Local Excel Data Source

Creating a clean copy of your data and storing it locally resolves most mail merge connection issues caused by cloud sync delays or unusual formatting.

Cloud synchronization services like OneDrive can sometimes interrupt the data connection between Word and Excel. Additionally, complex cell formatting or hidden data in the original spreadsheet can prevent Word from correctly parsing the recipient list. Transferring your data to a clean, local file is the most reliable fix.

Create a new Excel workbook

Open your original Excel file, copy the recipient list data, and paste it as plain text or values into a brand new Excel workbook.

Save the file locally

Save the new workbook to a local folder on your computer's hard drive (such as your Desktop or Documents folder) rather than a synced OneDrive or SharePoint directory.

Connect the list in Word

Open a new Word document, navigate to the Mailings tab, click 'Select Recipients', choose 'Use an Existing List', and browse to select the new local Excel file.

Verify recipient data

Click 'Edit Recipient List' on the Mailings tab to visually confirm that the names, emails, and data fields have successfully loaded into Word.

Reconnect to a Clean, Local Excel Data Source

Data Privacy Note: If you ever need to share your file for troubleshooting on public forums, always replace real names and emails with dummy data to protect privacy.

Solution 2

Temporarily Disable Add-ins and Automated Signatures

Third-party Word add-ins and automated email signature tools can sometimes interfere with the mail merge generation process.

Easy Mail Merge with WPS Office

Perform Seamless Mail Merges with WPS Writer

WPS Office offers a fully integrated, highly stable Mail Merge feature that connects spreadsheet data to your documents flawlessly, bypassing common sync and formatting errors.

1. Open the Mail Merge Tool: Launch WPS Writer, open your template document, and navigate to the References tab. Click on 'Mail Merge' to display the dedicated toolbar.
2. Connect Your Spreadsheet: Click 'Open Data Source' and browse your computer to select your .xlsx or .xls recipient list.
3. Insert Merge Fields: Place your cursor where you want data to appear, click 'Insert Merge Field', and choose the appropriate column headers (e.g., First Name, Email).
4. Complete the Merge: Click 'Merge to Different New Document' to generate printable letters, or select 'Merge to Email' to send your bulk communications.

Native compatibility with Microsoft Word (.docx) and Excel (.xlsx) formatsIntuitive Mail Merge wizard for quickly generating bulk emails, letters, and labelsStable performance with both local and cloud-stored recipient listsLightweight software design that consumes fewer system resources

microsoft office alternative - wps office

Frequently Asked Questions

Why does my mail merge recipient list appear blank in Word?

A blank recipient list usually occurs if the Excel file has blank rows at the top, lacks proper column headers, contains complex merged cells, or if Word is struggling to read a file actively syncing to OneDrive.

Does it matter if my Excel list is saved on OneDrive?

Yes. While OneDrive is supported, real-time cloud synchronization can sometimes lock the file or cause connection delays in Word. Moving the file to a local folder often resolves these connectivity bugs instantly.

Do I need to paste my Excel data in a specific format?

It is highly recommended to paste your data as 'Values' or plain text into a new workbook when troubleshooting. This strips away hidden macros, complex formulas, and unusual cell formatting that can confuse the mail merge wizard.

Document & File Issues