File Sharing Problems

How to Fix Lost Word Mail Merge Data Source in Shared OneDrive or Teams

Adam Davis Oct 1, 2026 869 views

Question details

Users need to resolve an issue where a Word document loses its connection to an Excel mail merge data source when accessed by different collaborators in a shared cloud folder.

Fixing Lost Word Mail Merge Data Sources in Shared OneDrive or Teams Folders

Product: Microsoft Word, Microsoft Excel, OneDrive, Teams
Device & OS: not provided
Scenario: Collaborating on a mail merge document linked to an Excel file within a shared OneDrive or Microsoft Teams folder.
Observed behavior: The mail merge works perfectly for the document owner, but other users receive errors or find that Word searches for the data source in a default local folder instead of the shared location.

Before you start

Ensure that all collaborating users have fully synced the shared OneDrive or Teams folder to their local computers using the desktop sync client.

Solution 1Recommended

Relink the Data Source Using Standardized Sync Paths

Standardize the local synced folder paths for all users and manually relink the Excel data source using the Mail Merge Wizard.

Microsoft Word typically relies on absolute file paths for mail merge data sources. When users sync a shared OneDrive or Teams folder, the local file path includes their specific Windows username. Because these usernames differ between collaborators, Word cannot locate the data source for other users unless the file is manually relinked from their localized sync folder.

Sync the shared folder

Ask all collaborators to sync the shared Teams or OneDrive folder to their local Windows File Explorer or Mac Finder.

Open the Word document

Open the Word document that is experiencing the mail merge connection issue from the locally synced folder.

Select recipients

Navigate to the 'Mailings' tab on the top ribbon and click on the 'Select Recipients' button.

Choose an existing list

Select 'Use an Existing List' from the dropdown menu that appears.

Relink the Excel file

Browse to the shared synced folder on your local drive, select the Excel data source file, and click 'Open' to re-establish the connection for your user profile.

Relink the Data Source Using Standardized Sync Paths

Best Practice: To minimize disruption, ensure everyone opens the files from their locally synced File Explorer folder rather than directly from the web browser or Teams interface.

Solution 2

Host Files on a Mapped Network Drive

Use a shared network drive with an identical drive letter for all users to guarantee the exact same absolute path.

Perform Mail Merges Easily with WPS Office

Use WPS Office to Create Reliable Mail Merges

WPS Office provides a highly compatible and user-friendly Mail Merge feature. You can easily link spreadsheets to your text documents for bulk mailing, certificates, and labels with a smooth, guided process.

1. Open your document in WPS Writer: Launch WPS Office, open your template document, and navigate to the 'References' tab on the top menu.
2. Open the Data Source: Click on 'Mail Merge', then select 'Open Data Source' to browse for and select your spreadsheet file.
3. Insert Merge Fields: Place your cursor in the document where you want the specific data to appear and click 'Insert Merge Field'.
4. Merge the document: Click 'Merge to New Document' or 'Merge to Printer' to complete the process and generate your personalized files.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) file formatsIntuitive Mail Merge wizard for quick and straightforward setupLightweight and fast, ensuring smooth operation even with large data listsFree to download and use for your essential office processing tasks

Frequently Asked Questions

Why does my mail merge data source get lost when sharing via Teams?

Microsoft Word typically saves the absolute path to the Excel data source, which includes your specific Windows username (e.g., C:\Users\YourName\...). When another user opens the file, their Windows username is different, which breaks the file path and causes Word to lose the connection.

Can I use relative paths for Word mail merge in OneDrive?

Word natively relies on absolute paths for its mail merge data connections. While there are advanced workarounds involving editing field codes, the most reliable and straightforward method for cloud-synced folders is for each user to manually relink the file using the 'Select Recipients' button.

How do I check my current mail merge data source path?

In Word, navigate to the 'Mailings' tab and click 'Edit Recipient List'. Look for the 'Data Source' box in the resulting window; it will display the full file path that Word is currently attempting to use.

Document & File Issues