Create contact list omit duplicate addresses
Hi, I am looking to create a mailing list for my database. Many of my records share an address. I would like to be able to create a list that would group the household records under one address or at least have a list that would omit the duplicate mailing addresses and show only one address per household. Is there an easy script I can write to accomplish this? I have been doing it by exporting my list into excel and then finding the duplicates and using the excel file to create my mailing labels, but would prefer to do it all in Filemaker.
I am using Filemaker Pro11
Any assistance, thoughts, guesses would be most appreciated.