exporting email addresses from mysql??

[Graveyard666]

I checked on a couple contribs but I couldn't find one to do what I need it to.

 

What I want is to export (past) and capture (future) customer email addresses into a .txt file so I can subscribe them to our mailing list (Mail Mojo).

 

 

 

 

jeff

[Rob123]

A quick and dirty solution is to export them using phpmyadmin (or your favorite mysql connector)

 

select customers_firstname, customers_lastname, customers_email_address from customers where customers_newsletter = '1';

 

HTH,

Robert

[ddp]

A quick and dirty solution is to export them using phpmyadmin (or your favorite mysql connector)

 

select customers_firstname, customers_lastname, customers_email_address from customers where customers_newsletter = '1';

 

HTH,

Robert

 

Hi there I tried this export but the list it exported did not get all the names it should have. Some were missed could there be a problem with the above code?