I live in an HOA with 1631 homes. Each home has multiple email addresses (people) living at that address. There is a master database with all of that information. With homes changing owners or people in the homes changing emails, what I would like to do is have a spreadsheet that I can create from that master database that keys off of the home address. Within that address it would house all the emails for the people living at that address. Each time I import that information into Constant Contact, it would update those email addresses. IE Address: 12345 my street Name 1: My Name 1 Email 1: My email 1 Name 2: My Name 2 Email 2: My email 2 Address: 98765 my street Name 1: My Name 1 Email 1: My email 1 Name 2: My Name 2 Email 2: My email 2 By doing this, I believe I can take a periodic download in spreadsheet format from my master database and import it into Constant Contact. It would then replace all of the names and emails per address. Is this possible? If not how do I handle this type of situation and do not have a manual process to keep our master database and Constant Contact in sync. Note, it goes without saying that an email campaign would pickup each of the emails within the address to send to each recipient. Thanks mitch
... View more
