Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Exporting email addresses


Bexford

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...