Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product

Is It Possible To Send A Mass Email To All Users?

I've done a little research and from what I've read, it looks like it's not possible without using a plugin that connects to a third party website. But i'm also unsure if those plugins even work for 2.6. I know that an alternate method would be for me to just extract all of the users emails through phpmyadmin or something similar, and send out a mass email using a regular email client, but I was just wondering if it can be done through vanilla?

Comments

  • phreakphreak VanillaAPP - White label iOS and Android App MVP

    Currently not in the core and I don‘t know of a plugin doing that. A plugin like that would need to ensure sequential mailing as most servers would cap mailing at 300, 500 or another number of E-Mails per 15 minutes (example).

    StaticCory
  • @phreak

    Thanks! I guess i'll attempt to extract all of the emails using phpmyadmin, and email normally.

  • Just an update. I decided to do a little research, and found a way to extract the email from phpmyadmin, very easily. I went to GDN_User, hit SQL tab at the top, and changed

    SELECT * FROM GDN_User WHERE 1

    to

    SELECT Email FROM GDN_User WHERE 1

    and I hit "go".

    Everything turned out great, and the email list appeared exactly how I wanted it. I was just wondering if this was the proper way to do this, and If anything bad will come as a result. A query is just a question, so I assume it didn't actually "change" anything, but i'd just like to confirm that, anybody have any idea?

  • R_JR_J Cheerleader & Troubleshooter Munich Moderator
    edited July 10

    That query is fine and will do no harm, but it can be shortened. If your query should show all rows, without any restrictions, there is no need for the "where" part.

    But I guess you do not want the mail address of deleted users and maybe also not the banned users.
    WHERE Deleted = 0 AND Banned = 0

  • @R_J @jenis

    Thanks guys. R_J, right when I clicked sql, that line was already there, so i basically just inserted "email" to replace the asterisk. The result was just the emails, nothing else. It did include deleted users and banned users, but I don't have too many, so it wasn't an issue. But now I know for next time, that it can be even shorter, thanks!

Sign In or Register to comment.