Hi all,
I rec'd a list of bad email addresses back from a recent email campaign, 385 of them to be exact. Since we pay by the email we want to remove these bad addresses.
Here is the rub, some of the addresses are marked as primary and used as website logins, (although to tell the truth I don't know when the last time was these people used them.)
If I go into test and run a SQL query to change the T_EADDRESS.inactive field to 'Y' it updates the table, but does nothing to the record in Tess. The email address is still set to active.
Any ideas what I'm doing wrong?
since you mentioned web logins, just for clarification that table is T_CUST_LOGIN.
Thank you all.
Gloria, I'd love to see your script, but I don't see the attachment.