Mail Merge Duplicate Recipients: Find the Right Rows

By Docs from Excel · 22 September 2026

When mail merge creates two letters for the same person, check the selected source records before deleting names. A duplicate row, two different people with the same name, and one person needing two documents are different cases. Decide what makes a document unique before changing the list.

Keep a copy of the workbook and template first. Work on an export for the current batch so you can reverse a mistaken exclusion. This guide concerns repeated recipients or documents; an extra letter with no details belongs to the separate blank-record checklist.

Define one row’s job

“One letter per customer” and “one letter per order” require different rules. Customer ID may identify a letter in the first case. In the second, one customer can legitimately appear several times because each order needs its own document. Names and email addresses alone may not distinguish those documents.

For one document per order, the example has three distinct order IDs. For one document per customer, it has two customer IDs, but the two orders for C101 still need a decision about which information belongs in that customer’s document. Removing a row does not combine its order details into another row.

Inspect the recipients Word will actually use

In desktop Word, open Mailings → Edit Recipient List and review the selected records. Microsoft describes Find duplicates as matching first and last names. It lets you deselect unwanted entries; deselecting does not delete the record from the underlying list. See Microsoft’s recipient-list documentation.

Use the match as a review prompt. In the example, every row has the same name, but not every row is a duplicate document. Compare the customer and order identifiers with your batch rule. If those identifiers are absent from the source, resolve the ambiguity before doing a large merge.

Clean an export in Excel when the duplicate is confirmed

Excel’s Data → Remove Duplicates uses the columns you select to identify duplicates. Selecting only Name and selecting Customer ID plus Order ID are different operations. Microsoft recommends copying the original data before permanent removal; see filtering unique values and removing duplicate values.

On your copy, review conflicts before removal. Two rows with the same order ID but different amounts should not be silently reduced to whichever happens to remain. Confirm the correct version with the source owner, then prepare the export using the intended records.

Save the cleaned export under a distinct filename. Reconnect Word to that file and verify the recipient list again. Editing one workbook while Word remains attached to a similarly named older file can make an otherwise correct cleanup appear ineffective.

If the source has no duplicate record

Compare the output with the source IDs. Two documents showing the same name may contain different orders, which could be expected. If they also show the same order ID, confirm the connected sheet or range and the selected recipients before investigating the template.

For a label layout, inspect the merge rules as well as the data. Repeated content inside a single document is a different symptom from two selected source rows generating two documents. Avoid changing data until you know which symptom you have.

Run a deliberately small test

1. Choose a few invented records, including two names that match but belong to different IDs.
2. Write down the expected number of documents according to your batch rule.
3. Preview the records and inspect identifiers as well as names.
4. Generate the test output and compare its count and contents with that expectation.
5. Only then repeat the workflow with the prepared full export.

Will a different document tool deduplicate the list?

Do not assume it will. Prepare the correct rows before changing tools. Docs from Excel is a batch document workflow, not a substitute for deciding which business records belong in the batch.

Try the matching files in the certificate starter kit, or open Docs from Excel with your prepared template and list. Check the output and the current download terms before purchasing. If each result needs its own filename, see custom names for merged files.