Sending an e-mail to all members except 1?

[bobs409]

Im currently using vBulletin 2.3.4

Is there a way to send an e-mail to every registered member except for 1 member?

The only thing I see is to manually add names and build a list. I have over 500 members

Thanks,


Bob

[Jake Bunce]

I don't see an exclusive search option, so what you need is a search criteria that will match all but the excluded user.

Do you use COPPA on your forums? If not you might be able to use the Parent's Email field as a search flag by running a query on your database to set a value in that field for all but the excluded user. It's a little crude but it should work.

Run this query on your database, where X is the userid of the excluded user:

UPDATE user SET parentemail='flag' WHERE userid!=X

Then send your email with the search criteria and parent's email contains flag.

Afterwards you can clear all parent emails again by running this query:

UPDATE user SET parentemail=''

That's two single quotes. You should backup before querying your database.

[bobs409]

Thanks Jake, I'll give it a try.


Bob