XF 1.3 List of bounced emails

[Dakis]

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.

 

[Brent W]

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.

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.

 

[Dakis]

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

 

[Brent W]

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

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

 

[Dakis]

Ok thanks then, I was afraid it might be an issue, I'll give it a go

 

[Biarritz64]

have you find a solution?
can you share

Thank you

 

[jauburn]

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.

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.

 

[Dakis]

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