Use a SharePoint List as a Word Mail Merge Data Source
Question details
Use records from a SharePoint list as the recipient data for a Word mail merge, with a way to update the source when records change.

- Product
- Microsoft SharePoint and Microsoft Word
- Device & OS
- not provided
- Scenario
- A user wants to create mail merge documents in Word from records maintained in a SharePoint list.
- Observed behavior
- The desired result is a Word mail merge connected to list records that can be updated when the SharePoint data changes.
Check that you can access the SharePoint list and that its columns contain the fields needed for the merge. Make sure the list view includes the records and columns you want to export.
Export the SharePoint List and Connect It to Word
Use an Excel workbook or CSV file as the Word mail merge recipient source.
Open the list in SharePoint and select Export > Export to Excel or Export to CSV, if available. Open the Excel export and save it as a workbook, or save the CSV file.
Open the exported file in Excel and verify that the column headers and recipient records are present. Save the file before connecting it to Word.
Open the merge document in Word and choose Mailings > Select Recipients > Use an Existing List. Select the exported workbook or CSV file; if prompted, choose the worksheet or table containing the records.
Use Mailings > Insert Merge Field to add the list columns to the document, then select Preview Results to check the recipient data.
If the Excel workbook has a working SharePoint data connection, open it in Excel, select Data > Refresh All, and save it. If it does not refresh, or if you used CSV, export the list again and update the source in Word through Mailings > Select Recipients.

Use a SharePoint Contacts List Through Outlook
Use Outlook contacts as the recipient source when the SharePoint contacts list supports synchronization with Outlook.
Work With Exported List Data in WPS Office
WPS Office is a free, lightweight alternative for working with exported list data and documents. Its familiar interface and Microsoft Office format support make it easier to move existing files into your workflow, although it does not fix Word or SharePoint integration.

Frequently Asked Questions
Will an exported SharePoint list update automatically in Word?
Not necessarily. A CSV is a snapshot. An Excel export may have a SharePoint data connection that can be refreshed through Data > Refresh All in Excel. Save the workbook and check the recipient list in Word after refreshing.
How do I use an exported list in Word mail merge?
In Word, select Mailings > Select Recipients > Use an Existing List, choose the exported Excel or CSV file, and select the worksheet or table if prompted.
What should I do when new SharePoint records do not appear?
Open the Excel source and try Data > Refresh All, then save it. If there is no working connection, export the list again and select the updated file in Word. Check Mailings > Edit Recipient List for the new records.
Can I use any SharePoint list as Outlook contacts?
No. The Outlook option is intended for supported SharePoint contacts lists, and Connect to Outlook may not be available in every environment. For other lists, use an Excel or CSV export instead.




