WordPress.org

1. swordfish
   Member
   Posted 6 years ago #

   Do any of you know a plugin which can catch all emails and store in one place and then have an interface for something like a mailing list and allow the blog owner to send a mass email to all who commented in the blog?

2. Alex Mills (Viper007Bond)
   Moderator
   Posted 6 years ago #

   No need to catch them and store them, it's already done in the comments table.

   And that'd be SUPER easy to do:

   while($emails = $wpdb->get_results("SELECT comment_author_email FROM $wpdb->comments GROUP BY comment_author_email")) {

   mail($emails->comment_author_email, 'Subject', 'Message');

   }

   (Or at least I think that'd work.)

3. swordfish
   Member
   Posted 6 years ago #

   viper,

   I really dont know where to change this code.
   I hope you understand my requirement. I just want an interface to mail all commentators in my blog from my admin panel? the above code is going to help me? if so where do i add this code?

4. Alex Mills (Viper007Bond)
   Moderator
   Posted 6 years ago #

   The above code queries the database and sends an e-mail to everyone who's commented on your blog.

   If you're still lost and you really want an admin interface, and of course if someone wants to make it, then they can use that code.

5. Kafkaesqui
   Moderator
   Posted 6 years ago #

   I would recommend an *email subscribe* plugin instead. The last thing I expect when commenting on a blog is that the blog owner will use it to spam me...

   http://codex.wordpress.org/Plugins/Mail

Topic Closed

This topic has been closed to new replies.