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?
I just uploaded it to my profile on the web site.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Nick TorresSent: Friday, January 07, 2011 12:08 PMTo: Gloria OrmsbySubject: Re: [Tessitura Technical Forum] inactivating bad email addresses
Thank you all.
Gloria, I'd love to see your script, but I don't see the attachment.
From: Nathan Campbell <bounce-nathancampbell1231@tessituranetwork.com>Sent: 1/7/2011 10:51:58
since you mentioned web logins, just for clarification that table is T_CUST_LOGIN.
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
Thank you very much. That will come in handy.