How to send to List A, but exclude those people who also appear on List B

SOLVED
Go to solution

How to send to List A, but exclude those people who also appear on List B

The subject header says it all.

 

I've got a giant list of customers in California.

 

But I've also got a list of "Customers of Client X".

 

Now I want to do a mailing to my giant California list, but need to EXCLUDE anyone on that list who is also in the "Customers of Client X" list.

 

Can someone please explain how you can easily do this in Constant Contact? 

 

I have been using another email provider, and this was simple to do.  You simply selected the California list as a "send to" list, and told the system to exclude anyone on the "Customers of Client X" list.

 

Thanks in advance for any help.

 

Michael

1 ACCEPTED SOLUTION
Employee

Hello @TrustinusLLC , 

 

UPDATED: December 2019

 

Users with less than 10,000 contacts in their account have the option to tag the unwanted list and limit their recipients by this tag. This feature is however not available in account with over 10,000 contacts in it. Instead we suggest following these steps to create a list for the desired tagged contacts and schedule the email to this list instead.

 

---------

 

At this time, in order to perform this action within your account you would need to create the list of contacts to send to.  In order to do this, there are a few steps involved: 

 

  1. Create a duplicate list of the California list, you can name this something like California minus Clients of X. 
  2. Go to the "Customers of Client X" list (the one you want to exclude).  Select all of the contacts. 
  3. Remove these "Customers of Client X" contacts from your new California minus Clients of X list.
  4. Once this action is complete, the new list will be left with all contacts who were within the original California list, that were not on the Clients of X list.

 

The other option, if you are using a third-generation campaign, is to add all of "Clients of X" to a tag and then choose the "Don't send to contacts who are also tagged with" option when scheduling an email. 

 

If you need any help with this or have further questions, please let us know.  

View solution in original post

80 REPLIES 80
Regular Participant

With the "CC Analysis" tool you can subtract lists to do the trick for you. The "CC Analysis" tools was created to be used for analysing across multiple emails and have "adding","Subtracting" and "excluding" capabilities between lists more: http://www.mitdigitaleoje.dk/CCAnalysis/CC_Analysis.html

Consulting & Training

I have a master list of all my contacts that I regularly communicate with.  However, there are times were I want to exclude certain people from a particular mailing (don't want to promote a module to people that have already licensed it). 

Is there a way to exclude these people without downloading the entire list, removing them manually, and then uploading a new list?  If I remove them through CC, it removes them from everywhere, which I don't want to do.

Thanks for your help.

When I'm sending to only certain people on a established list, I start by making a copy of the entire list into a new temporary list. In the new list, I delete those people "only from this list". Then when I send the email I send to this new temporary list. Wishing you success.

Puzzle Master, Solutions Consultant
Specialist Web Accessibility
Solutions & Support for the solopreneurs; small and mid-sized companies.
Publisher, Author, Speaker

Solutions, not just answers.
One Size does NOT fit all.

I have the same question regarding sending a message to people to remind them to register for our conference. I don't want the message to go to those who have already registered. I can create a new list of the email addresses of the people already registered. Can I somehow tell Constant Contact to send it to everyone who is NOT on the list of people already registrered? I don't want them removed from my database, but I do want to exclude them from a single mailing our to unregistered people.

Regular Participant

Heeeeelllp,

 

I have a mailing list that I would like to send to all the members that are not already in another list.

 

Suggestions?

 

Bruce.

Hi,

 

 

What you could do is merge the original list into a new list, effectively making a copy of the original list. Once the list is merged, go into the new list and remove the contacts you would not like to mail to.

 

If there is a large amount of contacts that need to be removed, you can create a file that only contains the contacts you want to remove from the newly merged list and then upload those contacts to be removed from that list.

 


I hope this helps,

 

 

Jarrad

If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution"

Are you on Twitter? Follow me here!
Regular Participant

I am not exactly sure I understand what you are saying....

 

My final goal is to have members of one list click on a link that will have them opt-in to a different list. They need to choose to go there.  But I only want to sent the email to those who are not already in the that list.

 

Maybe this will help more...

 

Email to List A  ---> do you want to go to List B? (If member of List A is already on List B do not send the email)

 

Does this help?

Thanks for your time.

Hi,

 

What I am suggesting is removing the contacts that are already in list B from list A. Merging list A into a new list would allow you to remove the contacts that are already in list B without affecting the original list A. Merging a list creates a copy of the original list.

 

 

If this doesn't make sense, please private message me with your telephone number or call us at 1-866-289-2101 for assistance.

 

Thanks,

Jarrad

If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution"

Are you on Twitter? Follow me here!
Regular Participant

Gotcha! 

 

Thanks.

Regular Participant

What did I do wrong:

 

I created a new list

Merged List A (310 contacts) & LIst B (250) into List C (476)

 

There should be less than 310 contacts in LIst C for what I am looking for, right?

Hi,

 

I'm sorry if my instructions are not making sense. After you have merged the list, you will have everyone who is in list A as well as list B in a new list. What you would do is remove contacts that are in List A from List C creating a list that only contains contacts that are not already in list List B. This would then leave list C with only contacts that you want to send the email to.

 

I hope this makes sense. If not, please private message me your telephone number or call 1-866-289-2101.

 

Thanks,

 

 

 

 

Jarrad

If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution"

Are you on Twitter? Follow me here!
Regular Participant

So, thank you Jarred for clearing up what you were trying to say. But that is NOT what I am asking for. I am not asking for an AND option. I am asking or an XOR option in programming/logic

 

IOW, you are giving me A&B without the repeats (subset) -- and I can remove a few others if I feel like it.

lists.jpg

 

What I want is List A  EXCLUDING the Subset.

 

The only way that I can do it, if you all don't have any other ideas is export the two lists to an xl sheet or database, do it myself then import what I am looking for.

 

Thanks for your help though.

 

Bruce.

Hi Bruce,

 

 

I tried calling you with the number we have on file but was unable to get through. I am using the correct country code. Is there another number I can reach you at? I'm about to leave the office now, but I will be in the office tomorrow starting at 9:00 AM EST. If you want, private message me your telephone number and I will give you a call at a time you prefer tomorrow.

 

If you need immediate assistance, please call 1-781-472-8120.

 

 

Thanks,

Jarrad

If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution"

Are you on Twitter? Follow me here!
Occasional Participant

Hello Jarred,  I need to send an e-mail to about 85% of my mailing list.  I set up a second mailing list that did not contain the e-mails I didn't want sent.  My question is this will put me into the next pricing category, however, I don't have additional e-mails just a secondary list with all of the same e-mails but just fewer of them.  Does CC take note of that or will I have to pay the price of the next pricing tier?

Hi Kevin,

 

You are not charged for duplicate contacts. If these contacts were already in a previous list, you would not be charged for them. This would not bring you into a different pricing tier.

 

 

Thanks,

Jarrad

If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution"

Are you on Twitter? Follow me here!
Participant

I feel an "Exclude Lists" option would be very helpful for email marketing. Recently, I have been marketing to Executive contacts - these contacts are listed in an industry specific list (i.e. Architecture) as well as an Executive only list. There are many times when an Executive should not recieve the same message as their staff. Using an "Exclude List" option, I can then send an email to "Archtiecture" and exclude list "Executives" - instead of having a list for "Architecture", "Architecture Executives", "Construction", "Construction Executives", and etc.. You can see how many lists I would have to create. However, with an Exclude option I would only have to create one list for Executives and each specific industry.

Hi Garrett,

 

Thanks for your feedback. Do you have anyway of identifying the contacts that are executives based on their industry? If so, you could do a search based on those details and filter the industry specific executives into their own list. This would prevent you from manually doing it yourself. I know you didn't want to have to create a bunch of lists, but this would cut down on the time it would take if you were to do it manually.

 

I'm going to pass on on your feedback to see if this is something that we could add in the future.

 

Thanks,

Jarrad

If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution"

Are you on Twitter? Follow me here!
Occasional Participant

Agreed, Garrett.  This feature would be useful for us to exclude individuals who have already submitted a response to one of our surveys or taken advantage of one of our magazine subscription offers (so we do not continue to send them emails requesting action that they have already taken).

Regular Participant

100%. There are other email vendors who provide this option, and it is incredibly useful.

Regular Participant

Hi,

 

Currently we can send emails to multiple contact lists.  Is there a way to send emails to multiple contact lists then substract another list?

 

Sometimes we send emails to multiple lists but would like to make sure contacts in another list will not get these emails.

Jason,

 

If you include all the lists at the time your send your piece the system will automatically exclude duplicates.  If you wish to do a more conditional selection that would have to be done manually.

 

Tony Schaefer
Constant Contact Solution Provider -- Consultation and Remote tutoring available --
www.cliquemarketing.biz