Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

How do you export all customers' emails?

Tuan Le

Recommended Posts



I would like to know how to export all of my customers' emails from the store. Let me know if this is possible. I see there is an option to send out email to all customers under the admin console. However, I can't find any option to export the email addresses.


Thank you


Link to comment
Share on other sites

You can use this SQL

SELECT `customers_email_address` FROM `customers`

in your favorite mysql admin console export the record. ;)

Fan of OSC system.................

Comming From China.............

Link to comment
Share on other sites

Actually, you might only want the ones that have subscribed to the newsletter....

select customers_email_address from customers where customers_newsletter = 1


NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites


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

  • Create New...