Hello all,
We are TNEW users, and I'm wondering if anyone has advice on general maintenance with constituent accounts, to identify on a regular basis anyone who has an email address who does not have an online login.
I was hoping there was out-of-the-box criteria in list manager to identify patrons with/ without online logins, but I don't see one. Does anyone have a suggestion for how to find these patrons?
Thanks in advance,
Andrew
I just did this yesterday so I have some code for you! You should be able to add this to the bottom of your list criteria in manual edit mode. I was running it for people we were sending an online promo code. It may be easiest for repeated use to make a dynamic list with just this code (and not inactive account etc.) and grab that list every time you need it.
AND NOT EXISTS (select 1 from vs_cust_login (Nolock) where a.customer_no = vs_cust_login.customer_no)
Ann
Edit: I got too excited to share and skipped over that you were on TNEW. Hope this can still work for you.
Thank you, Ann! I am going to try this out.
Ann - thanks so much, it appears to work!