Is there a way to merge two lists, idenfity the duplicates between the two of them, and make those duplicates a seperate list?
I have two email products and I want to be able to send content to those who are subscribed to both lists
Solved! Go to Solution.
I'm interested in this as well, but I'm not sure there's a way to do it in Constant Contact. I use a formula in excel to find duplicates and then upload the lists back in. =VLOOKUP(A2,Sheet1!A:B,1,false)
I believe Constant Contact manages this issue for you. If a recipient resides in multiple list and you send an email to those multiple list, that person should only receive one email. You can easily test this by creating two test list and putting your email address in both list, then send an email to both list. If you only get one email, it works, otherwise if you get two - it doesn't. I hope this helps.
We do automatically check for duplicates when you send an email to more than one list. If a contact is on both lists, they will receive only one email.
If you are looking to identify the duplicates in both lists, you could export your active contacts and select "Show List" as a field to export. This will list all of your active contacts and display each list they are currently in.
I hope this helps,
If you want to see if someone is already in your contact list you can search for the email address before you add it to see if it is in any of your lists. If you want to see if the email address might have been previously removed or has unsubscribed, make sure to select all under Search Contacts. See the Screenshot below for help. (This is available on the Contacts tab.)
If you are adding the email address through the Paste or Type in fields, and you go through the steps to add the contact. After you submit the lists you want the contact(s) added to at the top of the page, we will show you the number added and the number updated, see this screenshot:
Hope this helps!
This post thread is archived, content is saved for education. Links will not be updated. If you need additional information please create a new post.