SharePoint Document Issues

How to Perform a Mail Merge with Files Stored on SharePoint

Elise WilliamsElise Williams Oct 14, 2026 875 views

Question details

The user needs to perform a Microsoft Word mail merge using documents and database files that are hosted on a SharePoint server.

How to Perform a Mail Merge with Files Stored on SharePoint
Product
Microsoft Word, SharePoint, OneDrive
Device & OS
not provided
Scenario
Attempting to generate customized documents in Word using a mailing list or database that is stored online in a SharePoint or Microsoft Teams library.
Observed behavior
Word mail merge is generally not supported directly with cloud-hosted SharePoint databases, preventing the user from successfully linking the online data source to the document.
Before you start

Ensure that the OneDrive desktop application is installed and running on your computer, and verify that your Microsoft account has the necessary permissions to access, view, and sync the target SharePoint or Teams library.

Solution 1Recommended

Sync SharePoint Files to a Local Drive for Mail Merge

Since direct mail merge with cloud databases is unsupported, syncing your SharePoint library locally using OneDrive acts as an effective and practical workaround.

By using the OneDrive desktop application, you can mirror your SharePoint or Teams document libraries directly to your local machine. This allows Microsoft Word to interact with the database as if it were a standard local file on your hard drive, bypassing cloud-compatibility issues during the mail merge process.

1
Open your SharePoint library

Navigate to the SharePoint site or Microsoft Teams channel in your web browser and open the document library containing your mail merge document and database (such as an Excel spreadsheet).

2
Sync files using OneDrive

Click the 'Sync' button located in the top toolbar of the document library. This will prompt the OneDrive desktop application to launch and begin mirroring the folder to your computer.

3
Wait for synchronization

Open your local File Explorer and locate the newly created SharePoint sync folder. Wait until the status icons next to your database and Word documents show a green checkmark, indicating they are downloaded locally.

4
Open the local Word document

Double-click the synced Word document from your local File Explorer to open it in the Microsoft Word desktop application.

5
Execute the mail merge

Go to the 'Mailings' tab on the Word ribbon, click 'Select Recipients', choose 'Use an Existing List', and browse to the locally synced database file in your SharePoint folder to complete the mail merge.

Sync SharePoint Files to a Local Drive for Mail Merge
Keep OneDrive Running: As long as the OneDrive desktop app remains running, any changes made to the local database file will automatically sync back to SharePoint, keeping your source data up to date for future mail merges.
Free Microsoft Office alternative

Experience Seamless Document Creation with WPS Office

If you frequently encounter limitations or sync complexities with Microsoft Office and SharePoint, consider WPS Office. It provides a lightweight, highly compatible, and user-friendly alternative for all your word processing and mail merge needs, without the heavy subscription fees.

  1. 1. Download and Install: Get the free WPS Office suite from the official website and install it on your computer.
  2. 2. Open Your Files: Launch WPS Writer and open your existing .docx and .xlsx files directly without any formatting loss.
  3. 3. Use Mail Merge: Navigate to the 'References' tab and select 'Mail Merge' to easily connect your spreadsheet data to your document.
Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Built-in, easy-to-use Mail Merge feature for your local and synced cloud documents.Lightweight software that runs smoothly on Windows, Mac, Linux, and mobile devices.Free to use with a familiar interface, ensuring quick and seamless migration.
microsoft office alternative - wps office

Frequently Asked Questions

Can I directly link a live SharePoint Excel file to a Word mail merge?

No, Microsoft Word currently does not support linking directly to cloud-based SharePoint or OneDrive Excel databases via a URL for mail merge. You must sync the files to your local drive first.

Why is the 'Select Recipients' list not updating with my SharePoint data?

If you are using a synced local file, ensure that the OneDrive app is actively running in your system tray and has successfully synchronized the latest changes from SharePoint to your local drive before running the mail merge.

Do I need admin rights to sync a SharePoint library for a mail merge?

You do not necessarily need admin rights, but you do need sufficient user permissions (typically 'Read' and 'Download' access) on the SharePoint library to sync the files locally using the OneDrive application.

Will making changes to the local mail merge database update it for others on SharePoint?

Yes, as long as your OneDrive desktop app is running and connected to the internet, any edits you save to the synced local database file will automatically be uploaded to SharePoint, updating it for all team members.