Originally Posted by sundance
We use to only have about 4k in returns and we do send the emails with a message on how to remove yourself from the email notifications.

But it is not possible to re move 13k in emails one at a time. So the big question is how to capture all of the returns and then do an export of that data / emails only and then remove it from the UBB database email?

Originally Posted by isaac
If 13K came back to you, then you already know their addresses are "UNdeliverable."

Write a SQL query and execute it within the CONTROL PANEL > DATABASE TOOLS > SQL COMMAND page.

Similar to the following:

update ubbt_USER_PROFILE
set USER_ACCEPT_ADMIN_EMAILS = 'off'
where USER_REAL_EMAIL = '[email protected]'

[email protected] would be where you insert the address you wanted to disable admin emails for. Do this for each address.

Write a batch to update your forum.
update ubbt_USER_PROFILE set USER_ACCEPT_ADMIN_EMAILS = 'off' where USER_REAL_EMAIL = '[email protected]'


Originally Posted by sundance
how to capture all of the returns

Originally Posted by sundance
13K are coming back

That set of data that comes back to you seems like a good place to begin generating a list with.

current developer of UBB.threads php forum software
current release: UBB.threads 8.0.1 // wip: UBB.threads 8.1.0
isaac @ id242.com // my forum @ CelicaHobby.com