Need some help gathering email addresses

Posted: 16 years ago 11 replies

INTERNET MARKETING

Hi Warriors,

When people leave messages on my blog, WordPress sends a copy of their comment to my email address. This notice includes their email address. I have about 5000 of these messages and I would like to send them an opt-in email.

Does anyone know of a way I can gather all these email addresses into a file so that I can send them an email. I use GetResponse and I know how to upload the email addresses. What I don't know is how to "lift them" into a file that I can then upload into my GetResponse account.

Thanks in advance!

#addresses #email #gathering

snidge

snidge

snidge

Posts: Threads: Thanks: Account age: less than a second

16 years ago

Have you checked WP web site? Maybe there is a plugin for that?
- [ 0 ] Thank this user
Signature

Check out my WSO for 60% off my autoresponder, Bulk Mailer, Opt In Software.
60% OFF Mail List Management Software! Multiple List Capabilities!
Steve MacLellan

Steve MacLellan

Steve MacLellan

Posts: Threads: Thanks: Account age: less than a second

16 years ago

I don't know what mail program you use, but most of them have an export function. For example, here is how to do it using Windows Mail:
How to Export Contacts and Email Addresses from Windows Mail - About Email

Once you have it in CSV format, you can open it in Excel, and strip out the columns you don't want (assuming you just want names and email addresses) and then import the list into your get response account.

Regards,
Steve MacLellan
- [ 0 ] Thank this user
Signature

Website building Discussion and Hosting
https://stevemaclellan.net

16 years ago

I think she just needs to get them from the database into a list in the first place though. I'm sure there is a plugin to do that. If not maybe that will be my next project lol.

[ 1 ] Thank this user
1 reply

Signature

Check out my WSO for 60% off my autoresponder, Bulk Mailer, Opt In Software.
60% OFF Mail List Management Software! Multiple List Capabilities!

16 years ago

Originally Posted by snidge

I think she just needs to get them from the database into a list in the first place though. I'm sure there is a plugin to do that. If not maybe that will be my next project lol.

If this is the case, she can export the email addresses from MySQL into a CSV file from the table wp_comments/comments_author_email.

Best Regards,
Steve MacLellan

[ 1 ] Thank this user

Signature

Website building Discussion and Hosting
https://stevemaclellan.net

daddyg

daddyg

daddyg

Posts: Threads: Thanks: Account age: less than a second

16 years ago

Going forward you might want to consider Robert Plank's Action Comments wp plugin. I'm not sure if it's available as a standalone product aswell but it's a bonus at Action PopUp.com

It puts a little checkbox option when people make comments asking if they want to receive blog updates. Integrates with Aweber and probably other autoresponders too afaik.
- [ 1 ] Thank this user
Darren Mothersele

Darren Mothersele

Darren Mothersele

Posts: Threads: Thanks: Account age: less than a second

16 years ago

Do you have phpMyAdmin on your host/server?

I think you can export this data straight from the Wordpress database.
- [ 1 ] Thank this user
- 2 replies
- seamusb
  
  seamusb
  
  seamusb
  
  Posts: Threads: Thanks: Account age: less than a second
  
  16 years ago
  
  Originally Posted by Darren Mothersele
  
  Do you have phpMyAdmin on your host/server?
  
  I think you can export this data straight from the Wordpress database.
  
  I am not sure that the OP will understand what phpMyAdmin is, so avoiding geek speak, here is the simplest explanation (note this is not a full explantion, just an overview)
  
  - phpMyAdmin is a web based GUI admin tool for managing MySQL databases, the standard database used in Wordpress.
  - Most web hosts give access to this tool. Check with yours...
  - The kind of information you are trying to get from WP is not standard, so you probably need to go straight to the database. This is why you need phpMyAdmin.
  - You would choose to export the comments table to CSV and then open the file in Excel to just take out the email address.
  
  Alternatively, you could try one of these WP mailing list plugins -
  
  A Trek Through Wordpress Mailing List Plugins - Email Mailing List Manager - Social Media Marketing Sys
  
  Perhaps if you can get a mail to all commenters, you could ask them to subscribe to you new list?
  
  - Seamus
  
  [ 2 ] Thank this user
- seamusb
  
  seamusb
  
  seamusb
  
  Posts: Threads: Thanks: Account age: less than a second
  
  16 years ago
  
  Browser is slow - posted twice , duh.
  
  [ 0 ] Thank this user
Solidsnake

Solidsnake

Solidsnake

Posts: Threads: Thanks: Account age: less than a second

Banned 16 years ago

You can use email extractor and upload the emails in your autoresponder...
- [ 1 ] Thank this user
SusanUSA

SusanUSA

SusanUSA

Posts: Threads: Thanks: Account age: less than a second

16 years ago

Thanks for the insights and ideas, Warriors. I should have stated that this is a blog hosted by WP and not me. I started this blog when I was totally broke, and now it gets so much traffic that I've been advised not to change anything with the hosting.

I will check with WP to see if there is a way I can get a download as they would be on their file . . . and I will also check out email extractor, which I have never used.

I'll check back and let you all know my success!

Thanks again!
- [ 0 ] Thank this user
Signature
SusanUSA

Believe me! If I can do it, so can you!

How a grandma made $12k+ in 5 weeks on her first IM offer spending less than $100!
camforbes

camforbes

camforbes

Posts: Threads: Thanks: Account age: less than a second

16 years ago

If you use Aweber, check to see if they have an email parser built for that format. Then you can just forward all those messages to your aweber list and it will suck out all the email addresses.
- [ 0 ] Thank this user

Need some help gathering email addresses

Trending Topics

Strategy for selling business management software to Gas stations!

Hello, happy to be here.

Is DL Guard still available to buy?

Hello all o/

How to host LinkedIn live events

Bouncer - Powerful and secure email verification platform