Exporting email addresses

[Bexford]

Hi all

 

I need to capture all the email addresses of my customers to dump into an Excel SS ..... is there a strightforward way to do this?

 

I have gone to the module where you can email all customers and tried to cut and paste but it wont work!

 

any ideas gratefully received.

 

cheers

Rebecca

[Rob123]

Try the following using phpMyAdmin or your favorite mySQL admin tool:

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

HTH,

Robert

[Guest]

Customer Export

Email export for Excel