Hey friends,
I've tried using graphical edit in list builder to find accounts that have and do not have email addresses but no matter how I set the operators, I find accounts with email addresses coming in when I am saying "not in" or "does not have". We want to make sure we can call guests who do not have an email address to advise about show postponements or cancellations.
- Chris
Have you tried creating a list of customers who have and email address? That might be more precise, and then you can use it to create another list of people not in that list.
In order to make sure we get an (or as many email addresses as possible) I am setting the search to pull replace individual with household and add all primary affiliates. This is causing a headache it seems as it's pulling all accounts making it hard to not have accounts that don't have any email at all. Le sigh...this is when I wish list builder was easier to use.
Hi Chris,
Gawain's approach is one I have used before to tackle this. Have you tried it this way?
List 1: Criteria are EAddress Type IN (select all types available), and EAddress Inactive IN (select No). And given your requirements, you'd set this list to "Replace individual constituents with household and add all primary affiliates."
List 2: Criteria is List DOES NOT HAVE (select List 1). You would then add whatever other criteria that are qualifying your constituents.
Hope that helps!
-Michael Flaherty-Wilcox, Tessitura Network