Check Word's duplicate list before removing anyone

Make5 minutes

The problem

Word flags two rows as duplicates, but they may be two different people.

Word's Find Duplicates box lists two rows for Sam Lee. A hand-drawn arrow points to the ID column, which shows R005 and R006, with the words two different IDs.

Why it happens

Find duplicates flags rows that look alike, like the same first and last name. It doesn't check your ID column. Two different people named Sam Lee look like a copy.

Fix it

  1. On the Mailings tab, click Edit Recipient List.

  2. Under Refine recipient list, click Find duplicates....

  3. Scroll right to your ID column. Compare the IDs in each group.

  4. Different IDs mean different people. Leave their boxes checked, or click Cancel.

In our test, Word flagged Sam Lee R005 and Sam Lee R006. Both stayed in the merge.

Watch for

One person with several rows, like one row per item, is flagged too. A box you uncheck here leaves that row out of the merge. Two rows with the same ID are a list problem, so fix those in your list.

For: Word for Windows

Microsoft's help: Edit mail merge recipients