@Poremsky.com

Tips & Tricks for Windows, Office, and Whatever

  • Home
  • Windows
  • Office
  • BlackBerry
  • Web Design
  • WordPress
  • Internet Explorer

Undo bounces in Email Marketer

Published on November 16, 2012 Last reviewed on May 3, 2017

I use the email marketer software from Interspire for my mailing lists and one week, yahoo.com bounced several hundred addresses. I knew most of the addresses were valid because one of the bounced addresses was my own, plus the bounce rate was 20x higher than normal.

Unfortunately, there is no way to bulk undo the bounce status in Email Marketer. I could edit each subscription manually but that would take "forever". I looked at the database in MySQL and saw that I could change the 'bounced' field to 0 to make the subscribers active again.

I used this SQL query to see all of the yahoo addresses and try to identify the bounced value that represented the subscribers who were bounced on the date in question:

select * from `db`.`email_list_subscribers`WHERE `domainname` = "@yahoo.com"

Once I decided on the date value to use, I used this query to look over the records that I wanted to update:

select * from `db`.`email_list_subscribers`WHERE `bounced` > 1351821100 AND`domainname` = "@yahoo.com"

Satisfied that the list included only the subscribers removed on the date in question, I used this query to change the bounced field to 0:

update `db`.`email_list_subscribers` set `bounced` = 0 WHERE `bounced` > 1351821100 AND `domainname` = "@yahoo.com";

This query did not change the bounce counts in the statistics, it only set the affected subscribers back to Active.

Share this:

  • Facebook
  • LinkedIn
  • Twitter
  • Print

Related posts:

Add a WordPress custom field and query on it Send email generated by a self-hosted WordPress website using Office 365 Creating your own Address bar searches Would anyone fall for this phishing email?

2
Leave a Reply

2500
1 Comment threads
1 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
2 Comment authors
2500
  Subscribe  
newest oldest most voted
Notify of
Eyal

Did you find a solution? I have the same problem...

Vote Up0Vote Down  Reply
August 11, 2013 4:40 am
Diane Poremsky

No, I don't know why they bounce in bulk. It doesn't happen often, and the messages aren't spammy.

Vote Up0Vote Down  Reply
August 13, 2013 2:05 pm

Recent Posts

  • Remove Office Licenses from Windows
  • Add a Confirm Unsubscribe Link in Sendy
  • Add the Recent Items Folder to Windows 10 Quick Access
  • A New Scam? Cashing in on Kohl's Cash
  • Windows 10: Pin Option Not Available at Logon

Recent Comments

  • Diane Poremsky on Add a Confirm Unsubscribe Link in Sendy
  • Andy on Add a Confirm Unsubscribe Link in Sendy
  • Andy on Add a Confirm Unsubscribe Link in Sendy
  • Mabel Hessel on How to open a registry file from a crashed computer
  • Brantley on Add Sequential Numbers to a Word Document

© 2019 · @Poremsky.com

wpDiscuz