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?
You also have to set the primary address flag to ‘N’ (a primary eaddress can’t be inactive). You might also consider setting the market_ind to ‘N’ as well, and then when you run extractions, the e-mail won’t get pulled that way as well.
Lucie