How to Extract Names and Email Addresses From Wordpress comments

by Admin on January 31, 2010

Lot of people are searching this. Actually, when your blog grows up and you want to send e-mails for marketing or any other purpose, then you need to extrat e-mail address from wordpress comments.

This is a nice idea to do this.

For this

1-just login to your capnel and click on phpmyadim

phpmy admin will look similar to this window

Now you can extract email address from wordpress comments

2-Now, select your database, in this example we will select _wdp and click on it. then the screen appear will same as below one.

From the list given in left sidebar, just select "wp_comments"

Now you can extract email addresses from wordpress comments

3-choose "comment_approved(Ascending)" from "Sort by key" drop-down box which will sort the comments that you have approved instead of spammy comments.

4-Now scroll down and click on Export button

you can extract email addresses from wordpress comments

5-you can save this file as an Exel(.xls) file as well as csv file so that you can import all email address to yahoo,msn,gmail,etc…

you can extract email addresses from wordpress comments

Now you can import this file from yahoo,gmail or hotmail account.

Now start email marketing righ now. If you find this helpofull for you then leave a comment.

  • Stumbleupon
  • Google Buzz
Your Ad Here

{ 4 comments… read them below or add one }

1 ray ban store February 3, 2010 at 10:25 pm

I enjoyed the article and thanks in on to posting such valuable tidings as a substitute into of all of us to presume to, I be the commencement approximately it both of resource to and resourceful and I map out to let off it as down as I can.

2 Nicolas February 12, 2010 at 1:12 am

Hi, Interesting, I`ll quote it on my site later.
Thanks

3 Socco February 14, 2010 at 2:01 pm

Hello,
Thank you! I would now go on this blog every day!
Thanks
Socco

4 UGG Boots February 18, 2010 at 4:51 pm

This article was very useful for a paper I am writing for my thesis.

Thanks

Leave a Comment

You can use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <font color="" face="" size=""> <span style="">

Previous post:

Next post: