Use One Mail Merge Data Source for Multiple Word Documents
Question details
Use the same mail merge data source to create different types of letters or documents without preparing the data again.
- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- The user has one recipient list and needs to produce several document types from it.
- Observed behavior
- The desired result is to reuse the existing recipient data while selecting the appropriate content or template for each document.
Make sure the data source has column headings for the fields each document needs. If content should vary by recipient, add a column that identifies the letter or document type.
Connect each Word template to the same data source
Use separate templates when you need several document types from the same recipient list.
In Word, open the first letter or document template, then select Mailings > Start Mail Merge and choose the document type.
Select Mailings > Select Recipients > Use an Existing List, then choose the shared data source and, if prompted, its table or worksheet.
Use Mailings > Insert Merge Field to add the needed fields. Select Preview Results, then Finish & Merge > Edit Individual Documents to create the merged output.
Open each additional template and use Mailings > Select Recipients > Use an Existing List to select the same source. Insert its fields and run Finish & Merge again.
Use conditional fields to select letter content
Use one combined template when each recipient should receive content based on a value in the data source.
Reuse a recipient list across WPS Writer templates
Use the same recipient data source with separate templates in WPS Writer, then run a mail merge for each document type.
- 1. Open a template: Open WPS Writer and use File > Open to select the first document template.
- 2. Connect the data source: Open the Mailings or Mail Merge tools and choose Open Data Source to select the recipient list. Tool names and locations can vary by WPS Office version.
- 3. Add and check fields: Place the cursor in the template, use Insert Merge Field to add recipient details, and preview the records using the mail merge tools.
- 4. Merge each template: Use the mail merge tools to generate the output, then open each additional template and connect the same data source before merging again.

Frequently Asked Questions
Can I use the same Excel list for more than one Word mail merge?
Yes. In each Word template, select Mailings > Select Recipients > Use an Existing List and choose the same Excel workbook and worksheet.
How can Word choose different text for different recipients?
Add a column identifying the content type to the data source. In Word, use Mailings > Rules > If...Then...Else to compare that column and insert the appropriate text.
Does Word automatically create a separate file for every recipient?
Finish & Merge > Edit Individual Documents normally creates a combined document. You can split it manually or use an add-in that supports separate Word or PDF files.
Can one template create multiple document types for every recipient?
A combined template can contain multiple sections, but an IF rule typically selects content for a record rather than creating several separate files. For distinct document types, run a merge for each template or use a suitable add-in.




