OneDrive File Issues

Fix Word Mail Merge Cannot Find Excel List in OneDrive

Emma Brown Sep 28, 2026 869 views

Question details

The user is unable to locate or connect to an Excel data source stored in OneDrive when attempting to perform a Word Mail Merge.

How to Fix Word Mail Merge Not Finding an Excel List in OneDrive

Product: Word, Excel, OneDrive
Device & OS: not provided
Scenario: Creating Word mail merge documents or labels using a data list stored in an Excel workbook.
Observed behavior: The Excel file stored in OneDrive does not appear in the existing-list options, preventing the mail merge from accessing the cloud data source.

Before you start

Ensure that the Excel workbook containing your mailing list is completely closed before attempting to connect it to Word, as open files will block the data connection.

Solution 1Recommended

Move the Excel Data Source to a Local Drive Folder

Relocating the Excel file from OneDrive to a local directory ensures Word can securely establish an OLE DB connection to the data source without cloud URL conflicts.

Word's Mail Merge wizard frequently requires a strict local file path (such as a C: drive location) to process data arrays. Cloud-based URLs generated by OneDrive can cause the existing-list dialog to fail to recognize the file.

Create a local folder

Open File Explorer, navigate to the root of your C: drive, and create a new folder. Name it something easily identifiable, such as C:\Merge Files.

Copy the Excel file locally

Open your OneDrive folder, locate your Excel data list, and copy the file into the newly created C:\Merge Files folder.

Initiate Mail Merge in Word

Open your Word document, navigate to the 'Mailings' tab on the ribbon, and click 'Start Mail Merge' to select your document type (e.g., Labels or Letters).

Select the local recipients list

Click 'Select Recipients', choose 'Use an Existing List', and navigate to the local C:\Merge Files folder. Select your Excel workbook and click 'Open' to establish the connection.

Move the Excel Data Source to a Local Drive Folder

Keep the Document in OneDrive: You only need to keep the Excel data source in the local folder. The main Word document can still be safely saved and synced in your OneDrive.

Efficient Mail Merge Tool

Easily Create Mail Merge Documents with WPS Office

Avoid complex cloud syncing errors by using WPS Office. WPS Writer seamlessly integrates with WPS Spreadsheet, allowing you to quickly generate labels, letters, and emails from your local or cloud data sources with minimal setup.

1. Open WPS Writer: Launch WPS Writer and open your main document template.
2. Access Mail Merge: Navigate to the 'Reference' or 'Mailings' tab on the top ribbon and click on the 'Mail Merge' button.
3. Open Data Source: Click 'Open Data Source', browse your computer to locate your Excel or WPS Spreadsheet list, and click 'Open'.
4. Merge and Finish: Insert your desired merge fields into the document, then click 'Merge to New Document' to generate your final letters or labels.

Seamless Mail Merge integration between WPS Writer and SpreadsheetFully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsLightweight, fast, and highly intuitive user interfaceFree alternative with powerful document processing capabilities

microsoft office alternative - wps office

Frequently Asked Questions

Why does Word struggle to find Excel files in OneDrive during Mail Merge?

Word's Mail Merge feature utilizes OLE DB connections which require a standard local file directory path. OneDrive files often register as cloud URLs (e.g., https://d.docs.live.net/...), which the Mail Merge wizard cannot always parse as a valid data source.

Does syncing the OneDrive folder to my PC fix the issue?

It can, provided that 'Files On-Demand' is disabled for that specific file so it exists physically on your hard drive. However, moving the file entirely outside the OneDrive sync directory (like to the root C: drive) is the most reliable workaround.

What if I get an 'External table is not in the expected format' error?

This error typically occurs if the Excel file is corrupted, currently open in another window, or saved in a format that your current drivers do not support. Ensure the file is closed and try saving it as a standard .xlsx or .csv file before connecting.

Can I move the Excel file back to OneDrive after the mail merge?

Yes. Once you have finalized the merge and generated your labels or letters, you can move the Excel data source back to your OneDrive. You will just need to repeat the local-folder process the next time you run a new merge.

Document & File Issues