1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 List of bounced emails

Discussion in 'XenForo Questions and Support' started by Dakis, Jan 27, 2014.

  1. Dakis

    Dakis Well-Known Member

    I have generated a list with all the bounced email addresses from my forum. This list was created from a newsletter I've sent.

    What is the easiest way to put the members with these email addresses to another usergroup, and remove them from receiving emails from the forum?

    Note: the bounced emails are more than 4500.
     
  2. BamaStangGuy

    BamaStangGuy Well-Known Member

    You can do it with an SQL query. You just have to take their email address and then set the user for that email address to Awaiting Confirmation From Edit as a user state so that no more emails are sent out.
     
    Dan and Dakis like this.
  3. Dakis

    Dakis Well-Known Member

    THanks, that was my original thought, but won't the many thousand emails I have be a problem for an sql query?
     
  4. BamaStangGuy

    BamaStangGuy Well-Known Member

    Shouldn't be. Just use a WHERE IN query. I have done it a few times.
     
    Dakis likes this.
  5. Dakis

    Dakis Well-Known Member

    Ok thanks then, I was afraid it might be an issue, I'll give it a go :)
     
  6. Biarritz64

    Biarritz64 Active Member

    have you find a solution?
    can you share

    Thank you
     
  7. jauburn

    jauburn Well-Known Member

    I believe the BD Mails add-on does this. At least I'm pretty sure it's doing it on my forum. This is really an invaluable add-on that perhaps should be made into a feature of xenforo. This does three things: it gets the mail handling off of your server and puts it through Mandrill or another mail handler, it puts bounced users in a special user group, and it notifies those bounced users via a notice, after they log on, that their email is no longer valid and should be updated.

    My Mandrill rating is 99% with this thing installed, with 0 soft bounces, 0 hard bounces, 0 unsubscribed, and 1 spam complaint since installation six months or so ago. You can't beat that!

    The only downside is that those users with bounced email addresses no longer show in the "total members" count in the sidebar (and there were probably 600 or so), but that tradeoff is well worth the convenience of this tool.
     
  8. Dakis

    Dakis Well-Known Member

    Yeah I've used bd mails for this for 2-3 months now, so it's all good :)
     
    jauburn likes this.

Share This Page