SharePoint Document Issues

Fix Word Mail Merge Broken Links with Excel on SharePoint

Rana Garcia Sep 28, 2026 868 views

Question details

Users need a reliable way to link a Word mail merge document to an Excel data source hosted on SharePoint without the links breaking for other collaborators.

How to Fix Word Mail Merge with an Excel File Stored in SharePoint

Product: Microsoft Word, Microsoft Excel, SharePoint
Device & OS: not provided
Scenario: Multiple users need to collaborate on a Word mail merge document that relies on an Excel data source migrated to a shared SharePoint library.
Observed behavior: The mail merge links break or point to a specific user's local OneDrive folder instead of maintaining a stable SharePoint path for all users.

Before you start

Ensure that you have the OneDrive desktop sync client installed and that you have appropriate access permissions to the shared SharePoint document library.

Solution 1Recommended

Sync SharePoint to OneDrive Using a Uniform Local Path

Create a stable local path for all users by syncing the SharePoint library via OneDrive to prevent broken mail merge links.

Currently, Word mail merge does not reliably use a SharePoint URL as a stable data-source path. The most effective workaround is to synchronize the SharePoint files to a local drive using the OneDrive sync client and ensure that all collaborating users maintain the exact same local folder path structure.

Open the SharePoint Library

Open the shared SharePoint document library containing your Excel data source in a web browser.

Sync with OneDrive

Click the 'Sync' button in the SharePoint toolbar to synchronize the library with your local OneDrive client.

Establish a Uniform Path

Ensure all users collaborating on the document set up the exact same local directory structure (e.g., placing the sync folder in a shared public directory or mapping it to the same drive letter) so the absolute file path remains identical across machines.

Reconnect the Data Source

Open your Word document, navigate to the 'Mailings' tab, click 'Select Recipients', choose 'Use an Existing List', and select the Excel file from your newly synced local folder.

Sync SharePoint to OneDrive Using a Uniform Local Path

Submit a Feature Request: You can submit a request through the Microsoft Feedback Portal for improved SharePoint mail merge support to encourage native web URL functionality.

Free Microsoft Office alternative

Looking for a smoother document experience? Try WPS Office

If you are frustrated by complex workarounds for standard document tasks, WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office with seamless migration and familiar tools.

1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Documents: Launch WPS Writer and open your existing .docx and .xlsx files without worrying about formatting loss.
3. Use Mail Merge: Navigate to the References tab to easily connect your data sources and complete your mail merge.

Highly compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Built-in, intuitive Mail Merge functionality for seamless document generation.Lightweight design that runs quickly on both older and newer devices.Completely free basic version with a familiar, easy-to-master interface.

Frequently Asked Questions

Why does my Word mail merge data source link break when moving to SharePoint?

Microsoft Word's mail merge feature relies on absolute local file paths. When you migrate an Excel data source to SharePoint, the URL-based path is often not reliably maintained across different users' machines, causing the connection to break.

Can I directly use a SharePoint URL as my mail merge data source?

No, currently Word mail merge does not reliably support using a direct SharePoint web URL as a stable data-source path. You must sync the files locally via OneDrive or download them to use them as a data source.

How do I fix the 'Data source not found' error in Mail Merge?

To resolve this, go to the 'Mailings' tab, click 'Select Recipients', and choose 'Use an Existing List'. Then, navigate to the local synced copy of your Excel file on your computer and select it to re-establish the connection.

Document & File Issues