Pulling constituents with no email address

Unknown said:

I am trying to clean up our email marketing lists and for that would like to pull a list of constituents that don't have an email in their records. I have been trying to use the "EAddress=null" in list manager but that doesn't work. i also tried leaving the value blank but it won't let me.

When this came up here a while back I had trouble making this work with built-in elements, and so added a graphically edited one containing:

select customer_no

from t_customer c

where customer_no > 0

and inactive != 5

and not exists (

select 1

from t_customer x

outer apply FT_GET_EADDRESS (GETDATE(),null, null, null, x.customer_no, null) e 

where e.address is not null

and c.customer_no = x.customer_no

)

Unknown said:

I am trying to clean up our email marketing lists and for that would like to pull a list of constituents that don't have an email in their records. I have been trying to use the "EAddress=null" in list manager but that doesn't work. i also tried leaving the value blank but it won't let me.

When this came up here a while back I had trouble making this work with built-in elements, and so added a graphically edited one containing:

select customer_no

from t_customer c

where customer_no > 0

and inactive != 5

and not exists (

select 1

from t_customer x

outer apply FT_GET_EADDRESS (GETDATE(),null, null, null, x.customer_no, null) e 

where e.address is not null

and c.customer_no = x.customer_no

)

Thanks all for sharing! I will try and follow-up if I have any questions.