AnsweredAssumed Answered

Create contact list omit duplicate addresses

Question asked by aklobby on Apr 11, 2012
Latest reply on Apr 17, 2012 by aklobby


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.