Fix Word Mail Merge Not Updating Excel Data in SharePoint
Question details
Update a Word mail merge using an Excel recipient list stored in SharePoint.

- Product
- Microsoft Word, Excel, and SharePoint
- Device & OS
- not provided
- Scenario
- A mail merge document and its Excel data source are uploaded to a SharePoint library.
- Observed behavior
- The merge updates from the local Excel file but does not refresh from the SharePoint-hosted list.
Confirm that you can access the SharePoint library and that OneDrive sync is available on your computer. Check which Excel workbook and worksheet contain the current recipient list.
Sync the SharePoint library and reconnect the Excel data source
Use a synchronized local folder when a SharePoint web path prevents Word from refreshing the merge data.
Open the SharePoint document library in your browser and select Sync. Follow the OneDrive prompts to add the library to your computer.
Open the synchronized library folder on your computer, locate the mail merge document, and open it in desktop Word.
In Word, select Mailings > Select Recipients > Use an Existing List. Browse to the Excel workbook in the synchronized folder, select it, and choose the worksheet containing the recipient data.
Select Mailings > Edit Recipient List or Preview Results to check the data, then save the Word document. Ensure OneDrive has finished syncing any changes.

Edit Word Documents and Excel Lists with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents and spreadsheets. Its Microsoft Office format compatibility helps you move existing files into WPS, although it does not fix Word's SharePoint data connection.

Frequently Asked Questions
Why does my mail merge work locally but not from SharePoint?
The SharePoint web path may prevent Word from updating its connection to the Excel workbook. Sync the library with OneDrive, then reconnect the workbook through Mailings > Select Recipients > Use an Existing List in desktop Word.
How do I check whether Word is using the right Excel list?
In desktop Word, select Mailings > Edit Recipient List to inspect the recipients. If the data is incorrect, use Mailings > Select Recipients > Use an Existing List and select the correct workbook and worksheet from the synchronized folder.
Can I refresh the merge in Word for the web?
Word for the web may not support all desktop mail merge features. Open the synchronized document in desktop Word to reconnect the Excel data source and check the merge.
What should I do after someone updates the Excel list in SharePoint?
Allow OneDrive to sync the updated workbook to your computer, then reopen or check the merge in desktop Word using Mailings > Edit Recipient List or Preview Results.




