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

Hi Jason,

 

Tony is completely correct. If you send to all lists, it will de-dupe the ones that are in more than one list.

However, if what you want to do is to remove one list from the complete sending but are afraid that those contacts are on more than one list you're sending to, you can follow these steps.

Go to the Contacts tab
Merge all lists into a new list by using the Merge feature

Then go to the Exports link
Export the list you do NOT want to send to > save to your desktop

Then once exported, go back to the contacts link.  This time click on the Remove List link on the right.

 

Remove List.png

Then from here, choose the new list you made when you merged all contacts.

 

Then upload the file you exported.

 

This will remove all the contacts in that one list from your merged list.

 

Let me know if you have any questions!

Regular Participant

Hi Marissa,

 

Wouldn't moving contacts to the "Remove" list take them out of all currently subscribed lists?  If so that's not what we want.

 

The situation is more like that we have 2 big lists of contacts, and we send emails to individual lists as well as sending emails to both lists at once.  However occasionally there are contacts that we do not want to send emails to.  Our thought is to maintain a list for these contacts.

 

We still want to send them emails at times, but sometimes we don't.  So they still need to be in the 2 big lists.

 

If you merge your lists into a new list and then go into Remove, you can choose this new list and then when you upload the file, it will only remove those contacts from that new list you created. All other lists will remain intact.

So the original lists that you merged, will still have those contacts.

Does that make sense?

Regular Participant

Hi Marissa,

 

Got what you said now, thanks!

 

It also says removing more than 100 contacts may take 24 hours to process.  So we can't really use the new list until a day after.  Is that correct?

You're welcome! It probably won't take that long. Maybe an hour tops. :smileyface:

Regular Participant

Lets say I have a list, but I want to exclude certain members from it.

 

I want to send message to both the whole group and the excluded members, but the excluded group gets a slightly different message and no one gets two messages.

Hi There!,

 

I'd be more than happy to assist you with your list question today. In order to do that you would have to create two seperate lists, one with the people you want to send to with the excluded removed, and one list that contains the excluded on their own. From there you would send one email to list with the exluded email addresses missing, then create your second email and send it to the exluded list.

 

Does that make sense?

Sincerely

Jayson Gonzalez

Community Support

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!

your awesome! thank you soooo much!:smileyhappy:

Member

I have a general list with my entire database in. I just created a new list where I excluded some on the list because they are too far from the event I'm sharing. Does the do not mail list span both lists or will I be mailing to the second list people that opted out?

Kym Johnson
KSJ Marketing Communications
Offering marketing advantages for small businesses
Toll-free (844) 575-6584
info@ksjmarketing.com

Kym,

 

Thank you for reaching out to us! So you know, the Do Not Mail list and Removed list span across all lists of Active contacts in your account. If you don't want to send to an individual now, but may want to do so later, I would suggest either making a new list and moving your contacts to that, or simply removing those contacts, not Do Not Mail. That list is basically an unsubscribe and you can't get those contacts back.

 

Joe

 

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

Regular Participant

Hey Guys,

 

Recently i tried to exclude some people from a particular email by creating a new list and moving them to that list, however, it didn't work, they stayed in the original list as well. So what i had to do (because i was to silly to just come here and ask lol), was move those contacts to the 'do-not-mail' list. Now that i've sent t he email i wanted to exclude these people from, i can no longer remove them from the do not mail list, and add them back into their own list because it says they opted out, but i know for a fact they haven't! 

 

Can any light be shed onto this issue? it's only 15 contacts, but they're important contacts!

 

Thanks in advance, 

Joe.

Hi Joe,

 

I'd be more than happy to assist you with your question concerning moving contacts between remove and do not mail. Unfortunately do not mail is reserved for if you don't ever want to mail to that email address again. Removing contacts will allow them to be reimported back in because it's just in a removed status. The Do Not Mail status is mean't to not allow accidental reimporting of the contacts or ensuring that if someone doesn't want to receive email communications at all that they won't. Luckily there are a couple of ways to re add a contact that has been moved to do not mail, but they require having the contact opt back in manually as it will send them a communication for them to re opt in through the following process.


I hope this helps! Please let us know if this doesn't work for you.

Thank you!

Jayson Gonzalez

Community Support

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

Hello, I recently sent a personalized email to a specific list of people and I am going to send the same email (minus the personalization) to my general list. The question I have is can I suppress the contacts from the original list in the second eblast because they are also on the general list. Basically, I don't want these customers receiving the same email twice.

Hi Avi,

 

Yes, you can accomplish this by following these steps. There are quite a few steps but this will get what you need done.

 

  • Make a copy of the list you want to send to ( your general interest list) & name it something easy so you can recognize it
  • Export your list that you sent to & save it to your desktop so you can easily find it
  • Go back into the Contacts > click on Remove list
  • Choose the new list you created (the copy of general interest) under Step 1
  • Under Step 2 > import your exported file of the list you sent to
  • This will remove all the contacts you sent to from your copied General Interest list (thus not affecting your real General Interest List)
  • Then make a copy of your email and send it to the Copied General Interest list.

Viola! It's that easy!  Any questions, don't hesitate to ask!

 

This sounds like what I want to do... I have two lists and would like to send to one of the lists (A) but exclude the emails of a second list (B). 

 

I found this thread after a live chat support told us we couldn't do this... I'm wondering if you can help me by giving a little more guidance on which step I'm taking with which list. I'm having a little bit of trouble following the steps as they are...

 

Thank you!


@Marissa_R wrote:

Hi Avi,

 

Yes, you can accomplish this by following these steps. There are quite a few steps but this will get what you need done.

 

  • Make a copy of the list you want to send to ( your general interest list) & name it something easy so you can recognize it
  • Export your list that you sent to & save it to your desktop so you can easily find it
  • Go back into the Contacts > click on Remove list
  • Choose the new list you created (the copy of general interest) under Step 1
  • Under Step 2 > import your exported file of the list you sent to
  • This will remove all the contacts you sent to from your copied General Interest list (thus not affecting your real General Interest List)
  • Then make a copy of your email and send it to the Copied General Interest list.

Viola! It's that easy!  Any questions, don't hesitate to ask!

 


 

 

Hello Cathryn,

 

I see that you spoke with a rep who has escalated your issue up to our specialists.

 

Please let us know of the resolution and how we can assist further.

 

Thank you!

This is a feauture that should be automated.  You shouldnt have to load up liek that.  Others in this industry have the ability to click on a list(s) and then go to another area and say exclude this lsit(s).  Make it happen CC!

Anna Navarro
Social Support and Community
If you find my post helpful, and it answers your question, please mark it as an "Accepted Solution"
Occasional Participant

There was a note on another thread (started in 2007) of the same topic that you planned to have this released by 2012.  To say that your developers have started to work on it is a bit laughable.  Is this really being worked on and do you think it will be completed before it hits the decade mark?

Ladies and gentleman, we have a solution. First, you can accomplish this using tags, but that feature is only available if you have less than 10,000 contacts. For those who have more than that, here are test steps to send to List A, but exclude those people who also appear on List B:

  1. Copy List A, creating "List A to Be Filtered"
  2. Go to contact management, Select List B
  3. Click select all
  4. Click manage lists
  5. Click remove from lists,
  6. Then in the pop up, I click on "List A to Be Filtered", and click on remove.
  7. Send to "List A to Be Filtered"
  8. Do a happy dance.

Hello,

 

I just called about this because I didn't like hte messiness of the solution above. This one is much easier. Here are the steps:

 

1. Copy the main list

2. Go to the second list and select all the contacts

3. Click "Add Emails to List"

4. Deselect your copy of the main list

5. Hit Apply and you're done!

 

Much tidier!