Latest: Facebook Like Our Facebook Page For More Updates! | Twitter: @Tech_Terms

Sunday 31 January 2010

How to Extract Names and Email Addresses From Wordpress comments

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.


[caption id="attachment_357" align="aligncenter" width="525" caption="you can exctract email addresses from wordpress comments"][/caption]


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.

  • MBT Icons and buttons

    Tips And Tricks

    Our resources have been successfully got many tricks and tips and shared here too much. Check Yours!

  • choosing webhost for a blog

    Mobile Zone

    Mobile Reviews Shared with thier latest tricks and tips!

  • SEO Settings for blogger

    SEO

    Learn every single SEO tip that will boost your blog's ranking and organic traffic. We got them all!

  • Blogger widgets and plugins

    Check Softwares

    Why not take a tour of all great softwares? You Name it we have it!

  • become a six figure blogger!

    Get Facebook Tricks

    Learn Facebook Tricks!