Document Editing Problems

How to Combine Two Word Mail Merge Data Files into One

Huma Ashraf Ch Oct 19, 2026 869 views

Question details

The user needs to combine two separate data files into a single master data source to successfully perform a Word mail merge.

Product: Word
Device & OS: not provided
Scenario: Consolidating multiple mailing lists or contact databases before initiating a mail merge operation.
Observed behavior: The user has multiple separate data files and wants to append the records from one into the other to create a unified data source without duplicate entries.

Before you start

Ensure both data files use identical field names and the exact same column order to prevent data misalignment during the consolidation process.

Solution 1Recommended

Manually Append Records in Word

Combine the data by directly copying records from the second file and pasting them into the first file.

If your data sources are stored as standard Word tables, you can manually append the rows from one document to the other. Be careful not to include the header row from the second file, as you only need one header for your master data source.

Open the first data file

Launch Word and open the first data source file containing your initial list of records.

Copy the records from the second file

Open the second data file. Highlight all the data rows, making sure to exclude the top header row, and copy them (Ctrl+C).

Paste records into the first file

Return to the first file, place your cursor below the very last record, and paste the copied data (Ctrl+V).

Clean up the data

Review the combined list for any formatting differences, missing values, or duplicate records. Delete any duplicate rows to ensure clean mailings.

Save the master data source

Go to File > Save As, and save the document with a new name, such as 'Master_Mail_Merge_Data.docx'.

Use the file in Mail Merge

Open your main mail merge document. Navigate to the Mailings tab, click 'Select Recipients', choose 'Use an Existing List', and select your new master file.

Data Storage Recommendation: If your original data is stored in Excel or Access, it is highly recommended to append the records directly within those applications before importing the final file into Word.

Solution 2

Merge Existing Documents Using the Directory Feature

Use Word's Directory merge type to compile multiple data sources into a brand-new document.

Efficient Document Processing

Combine Data and Perform Mail Merge with WPS Office

WPS Office provides a highly integrated and seamless Mail Merge experience. You can quickly consolidate your mailing lists in WPS Spreadsheet and execute flawless mail merges in WPS Writer, saving you time and effort.

1. Combine data in WPS Spreadsheet: Open WPS Spreadsheet, copy the records from your secondary lists (excluding headers), and paste them at the bottom of your primary list.
2. Clean the data: Highlight your combined data, go to the Data tab, and click 'Remove Duplicates' to clean up your master list. Save the file.
3. Start Mail Merge in WPS Writer: Open your main document in WPS Writer. Go to the References tab (or Mailings tab) and click 'Mail Merge'.
4. Import the master list: Click 'Open Data Source', browse for the combined spreadsheet you just saved, and open it.
5. Complete the merge: Insert the necessary merge fields into your document, click 'View Merged Data' to preview, and select 'Merge to New Document' to finish.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Intuitive Mail Merge wizard makes linking data sources incredibly simple.Built-in 'Remove Duplicates' tool in WPS Spreadsheet for rapid data cleaning.Free and lightweight office suite for all your document processing needs.

microsoft office alternative - wps office

Frequently Asked Questions

Do the column names have to exactly match in both data files?

Yes, for a successful data consolidation, both files must have identical field names and the same column order. If they do not match, the merged data will be misaligned, causing errors in your final mail merge document.

How do I easily remove duplicate records after combining the files?

If you combined the files directly in Word, you will need to review the table manually or sort the table alphabetically to spot duplicates. For a much easier process, use Excel or WPS Spreadsheet to combine the data, where you can simply click 'Remove Duplicates' under the Data tab.

What happens if my data files are in different file formats?

If one file is a Word document and another is an Excel spreadsheet, it is highly recommended to convert them both to the same format first. Copying Word table data into an Excel spreadsheet is usually the best approach to ensure formatting consistency.

Will copying and pasting keep my original data formatting intact?

In most cases, copying and pasting standard text will preserve the data. However, be cautious with dates and currency formats. Always preview your combined list to ensure that formatting differences haven't altered your records.

Document & File Issues