SharePoint Document Issues

Use a SharePoint List as a Word Mail Merge Data Source

Muhammad TalhaMuhammad Talha Nov 20, 2026 868 views

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.

Use a SharePoint List as a Word Mail Merge Data Source
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.
Before you start

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.

Solution 1Recommended

Export the SharePoint List and Connect It to Word

Use an Excel workbook or CSV file as the Word mail merge recipient source.

1
Export the list

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.

2
Check the data

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.

3
Select the source in 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.

4
Insert and preview fields

Use Mailings > Insert Merge Field to add the list columns to the document, then select Preview Results to check the recipient data.

5
Update the source when needed

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.

Export the SharePoint List and Connect It to Word
Check refreshed records: An export does not necessarily update automatically. After refreshing or replacing the source, reopen the merge document if needed and check Mailings > Edit Recipient List before completing the merge.
Free Microsoft Office alternative

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.

Open and review exported Excel recipient data in WPS SpreadsheetsWork with Microsoft Word DOCX and Excel XLSX filesUse a familiar interface for everyday document and spreadsheet tasksMove existing Office files into a lightweight workspace
microsoft office alternative - wps office

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.