Hello everyone,
I am assisting our Development Department with an appeal and extraction. One of the requested parameters is to suppress constituent records that do not have an email address attached to them. Is there a standard List Manager parameter and condition that I can use that will say "Does not have any email address"?
Thanks,
Duane
Hi Duane,
How about EAddress Information Folder
Primary EAddress Flag
Does not have
Select both Yes and No
we use the following bit of code this segement should have the Suppr Flag checked
SELECT DISTINCT customer_no FROM t_customer (NOLOCK)WHERE customer_no not in ( SELECT DISTINCT customer_no FROM vs_eaddress (NOLOCK) WHERE Primary_ind = 'Y' )
Hi Chris,
Would Yes and No be selected on the same line, or set up as two separate criteria using the top and bottom panels?
Thanks Dale. I'll try this out as well.
Yes and No on the same line and same criteria.
Thanks again Chris. That appears to be working.