inactivating bad email addresses

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

I have a script (attached) that I use for coding hard bounces. These emails follow the same logic…they are not good emails. I created different steps that does the following:

1.      Unchecks the marketing flag

2.      Unchecks the Primary indicator

3.      Marks an email purpose to indicate the email bounced

4.      Unchecks other emails purposes (which we use to indicate what emails people will get).

You can modify this to do what you want, we like to have an email purpose (H) that shows us the email bounced. If you have any questions let me know.

Gloria

Gloria Ormsby

Director of Information Systems

Flynn Center for the Performing Arts

153 Main Street

Burlington, VT 05401

802.652.4506

802.863.8788 Fax

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?

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!

I just uploaded it to my profile on the web site.

Thank you all.

Gloria,  I'd love to see your script, but I don't see the attachment.