I have a mail merge, merging from Access. The query selects everyone who has expired items in their records. This prints on a report so I can send a letter letting the people know what is expired.



I want the letter to only use the address info the first time it shows up in the query. I have the report to refer to in order to add auto text into the letter about each item that is expired but I don't need 10 letters to the same person, one for each item that is expired.

I have tried placing a next record at the end of each letter but this only skipped every other record, not what I was looking for.