How to Perform a Mail Merge with Files Stored on SharePoint
Question details
The user needs to perform a Microsoft Word mail merge using documents and database files that are hosted on a SharePoint server.

- 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.
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.
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.
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).
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.
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.
Double-click the synced Word document from your local File Explorer to open it in the Microsoft Word desktop application.
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.

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. Download and Install: Get the free WPS Office suite from the official website and install it on your computer.
- 2. Open Your Files: Launch WPS Writer and open your existing .docx and .xlsx files directly without any formatting loss.
- 3. Use Mail Merge: Navigate to the 'References' tab and select 'Mail Merge' to easily connect your spreadsheet data to your document.

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.




