Hi there, I'm about to work on queries to pull up the mailing list for this year's Holiday Direct Mail. But with every Direct Mail, we always have issues with multiple donors that share the same address. We don't want to send multiple letters to the same family. It looks rather bad when the...

Hi Cynthia, Having a constituent's name appear multiple times in your query results will not result in a multiple labels being generated for that constituent when you use the query in Mail, Labels but I am often asked how do I get these names to appear only once so that I can print a nice list. If...

Sometimes it's easy to figure out why there are duplicate rows (looking at gifts and donor has more than one or output field has potential for more than one entry - ex: phone, attribute, code) and other times it's a challenge. As Jason suggested, removing output fields may resolve issue. Sometimes...