No announcement yet.

Sending an e-mail to all members except 1?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Sending an e-mail to all members except 1?

    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



  • #2
    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.


    • #3
      Thanks Jake, I'll give it a try.



      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.