Tuan Le Posted February 26, 2004 Share Posted February 26, 2004 Hi, 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 -Tuan Link to comment Share on other sites More sharing options...
SunYe Posted February 26, 2004 Share Posted February 26, 2004 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 More sharing options...
wizardsandwars Posted February 26, 2004 Share Posted February 26, 2004 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 More sharing options...
Tuan Le Posted February 26, 2004 Author Share Posted February 26, 2004 Thanks guys. I appreciate your input. Cheers -Tuan Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.