Hello guys, I have a wordpress blog which is in sub-domain right now but I have a plan to upgrade it to a top level domain when it gets much more popular. Anyway, lets get to the point. I am receiving more than 10 blog comments daily and I just want to extract the email addresses of those commentators. Is this possible? If yes then I would like to know the way. ~Alan
If your blog is hosted on wordpress.com, I think that the only way to retrieve all comments with their emails is to download all content by using the export tool (WP Admin → Tools). After that you'll have to filter all the emails somehow. If you are running your own WP, you can display the addresses from your database via the following SQL query in phpMyAdmin: SELECT DISTINCT comment_author_email FROM wp_comments WHERE comment_approved = '1' Code (markup): There is a tool for exporting results.
You can also use a plugin which is easier. I found this > http://www.xs650chopper.com/extract-commenters-e-mail-wordpress-plugins/ Hope it helps.