Hi all,
I searched the forum, but I had trouble finding the answer.

I have a database (example attached), and I need to contact over 1,000 people.

The problem...

I want to contact people about their missing items.

An individual with 3 missing items will have 3 letters created, instead of 1.

How do I create a mail merge that accounts for duplicate IDs; so that the mail merge will create 1 letter with the missing items, instead of 3?

Excel Help.xlsx