Suppressing accounts w/ no email address for extraction/ list

try this,

Select Distinct a.customer_no
From t_customer a (NOLOCK)
   LEFT JOIN vs_eaddress e (NOLOCK) ON a.customer_no = e.customer_no
      and E.primary_ind = 'Y'
      and isnull(E.inactive,'N') = 'N'
Where e.address IS NULL
union
Select Distinct a.customer_no
From t_customer a (NOLOCK)
   left JOIN vs_eaddress e (NOLOCK) ON a.customer_no = e.customer_no
     and E.primary_ind = 'Y'
     and isnull(E.inactive,'N') = 'N'
Where e.address =''

We use a suppression segment with the criteria  “eaddress type” and select “does not have” and highlight all eaddress types.

Best,  

Chuck Buchanan

We actually use this as part of our inclusion data rather than suppressing them, and we look for anyone with an EAddress like %@% so that we know the email address being included is formatted somewhat correctly.