how to automatically blacklist unsubscribed emails on interspire email marketer


Simply create a trigger which will insert unsubscribed users in the blacklist after every update on the subscriber table.

CREATE TRIGGER `banned_email` AFTER UPDATE ON `iem_list_subscribers` 
FOR EACH ROW INSERT IGNORE INTO ya_banned_emails 
(emailaddress, list, bandate)
SELECT emailaddress, ‘g’, UNIX_TIMESTAMP( ) 
FROM iem_list_subscribers
WHERE unsubscribed != ‘0’;

Leave a Reply

Your email address will not be published.