I have a mailing list in which there can more than one person from the same household. I need to be able to test for more than one record with the same address and then combine the names but with only one address on labels and/or form letters.
For example,
Address 1
John Jones
Judy Jones
Address 2:
Alex Frame
Gena Blue
Address 3:
Alice Brown
Fred Brown
Joy Brown
Address 4:
Lucy Green
Nita Red
Jack Orange
I have tried various possibilities, none of which even came close to working. I suspect I may have to first do a count of the number of people in a household but I'm not even sure how to do that.
Any suggestions?
For example,
Address 1
John Jones
Judy Jones
Address 2:
Alex Frame
Gena Blue
Address 3:
Alice Brown
Fred Brown
Joy Brown
Address 4:
Lucy Green
Nita Red
Jack Orange
I have tried various possibilities, none of which even came close to working. I suspect I may have to first do a count of the number of people in a household but I'm not even sure how to do that.
Any suggestions?