Template Issues

Use One Mail Merge Data Source for Multiple Word Documents

Ayan MasoodAyan Masood Nov 20, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

Connect each Word template to the same data source

Use separate templates when you need several document types from the same recipient list.

1
Open the first template

In Word, open the first letter or document template, then select Mailings > Start Mail Merge and choose the document type.

2
Connect the recipient list

Select Mailings > Select Recipients > Use an Existing List, then choose the shared data source and, if prompted, its table or worksheet.

3
Insert fields and merge

Use Mailings > Insert Merge Field to add the needed fields. Select Preview Results, then Finish & Merge > Edit Individual Documents to create the merged output.

4
Repeat for other templates

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.

Separate output files: Edit Individual Documents normally creates a combined document for that merge. To create a separate Word or PDF file for each recipient, split the output manually or use a mail merge add-in that supports individual files.
Create mail merges in WPS Writer

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. 1. Open a template: Open WPS Writer and use File > Open to select the first document template.
  2. 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. 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. 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.
Reuse one recipient list across multiple letter templatesInsert recipient fields and preview merged documentsWork with Microsoft Word DOC and DOCX filesUse a familiar document-editing interface
microsoft office alternative - wps office

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.