Hi all,
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.
Thoughts on accomplishing this? Thanks!
Fernando:
Criteria = Eaddress Type, Operator = Does Not Have, Value = [pick from your dropdown – Default eMail or Personal eMail or Assistant eMail, etc.].
Elizabeth
____________________________________________
Elizabeth Weisser
Director, Customer Relationship Management
P: 212.415.5596 | F: 212.828.3091
92nd Street Y, 1395 Lexington Avenue, New York, NY 10128
92Y.org | Facebook | Twitter
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Fernando Olalla Sent: Wednesday, May 07, 2014 4:21 PM To: Elizabeth Weisser Subject: [Tessitura Marketing Forum] Pulling constituents with no email address
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Hi, Fernando:
You could make a list of all constituents (“List A”), and a separate list of all constituents with an active, primary e-mail address (or however you define who has an e-mail address—“List B”).
Make a third list and include the Other > List criterion twice. What you’ll add will look this this:
List Has (1 value selected) – [put List A here]
List Does Not Have (1 value selected) – [put List B here]
I use this type of list all the time. It may be low tech, but it works.
Lucie
______________________________Lucie SpielerIT Development and Training ManagerFLORIDA GRAND opera8390 NW 25th StreetMiami, FL 33122
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.