Title: PlugIn for E-mail list from Comments
Last modified: August 19, 2016

---

# PlugIn for E-mail list from Comments

 *  [ffitton](https://wordpress.org/support/users/ffitton/)
 * (@ffitton)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/plugin-for-e-mail-list-from-comments/)
 * I’m looking for something that would generate a list or roster of people’s names
   and e-mails that have left comments on my blog. I assume this would be a plugin,
   but have yet to find one that can do it. Any advice would be greatly appreciated!
 * Thanks!!

Viewing 1 replies (of 1 total)

 *  [tugbucket](https://wordpress.org/support/users/tugbucket/)
 * (@tugbucket)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/plugin-for-e-mail-list-from-comments/#post-1259599)
 * if you have access to your page.php you can do something simple like make a new
   page in your admin. name it what ever you want. Make sure to make it password
   protected so as not to let just anyone see your visitors info.
 * in the page.php you can then do somehting like this:
 *     ```
       <?php if ( isset($_COOKIE['wp-postpass_' . COOKIEHASH])
        and $_COOKIE['wp-postpass_' . COOKIEHASH] == $post->post_password){
              echo "<table border=\"1\">";
               $result = $wpdb->get_results("SELECT comment_author,comment_author_email FROM $wpdb->comments where user_id='0' ORDER BY comment_author DESC");
               foreach ($result as $results) {
              echo '<tr><td style="padding: 6px; width: 180px;">' . $results->comment_author . '</td><td style="padding: 6px; width: 180px;">' . $results->comment_author_email . "</td></tr>";
       	   }
       	   echo "</table>";
       } ?>
       ```
   
 * It will make sure the password has been entered correctly and if so build a 2
   column table list the commentor and their email address. t will not list any 
   user that has admin access only visitors whos level is 0.
 * Note:
 * if your theme is using the list_pages function, that will now add your new page
   to the list. You might not want that so be sure to modify that function to exclude
   that page ID:
 * [http://codex.wordpress.org/Template_Tags/wp_list_pages](http://codex.wordpress.org/Template_Tags/wp_list_pages)

Viewing 1 replies (of 1 total)

The topic ‘PlugIn for E-mail list from Comments’ is closed to new replies.

## Tags

 * [comment plugin](https://wordpress.org/support/topic-tag/comment-plugin/)

 * 1 reply
 * 2 participants
 * Last reply from: [tugbucket](https://wordpress.org/support/users/tugbucket/)
 * Last activity: [16 years, 7 months ago](https://wordpress.org/support/topic/plugin-for-e-mail-list-from-comments/#post-1259599)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics