matpal Posted June 3, 2005 Share Posted June 3, 2005 So I use Emailbrain.com to send newsletters to my customers because I do not like the OsCommerce newsletter feature. However, I cant seem to figure out how to export all of the email addresses to the email brain server. I guess I need to start off by knowing where the file is located that I nee dto export. :blink: Thanks for any insight. Link to comment Share on other sites More sharing options...
wizardsandwars Posted June 3, 2005 Share Posted June 3, 2005 Not file, you need the table. You need to extract all of the customers form the customers table where the newsletter option = 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...
Guest Posted June 3, 2005 Share Posted June 3, 2005 It isn't in a file. It's in your database. Do you have access to it via some program like phpmyadmin or your host's control panel? If you do, you'll find a wealth of information in there. Try this query when you get there: SELECT customers_email_address FROM customers Link to comment Share on other sites More sharing options...
Guest Posted June 3, 2005 Share Posted June 3, 2005 Oh, yeah. Chris is right: SELECT customers_email_address FROM customers WHERE customers_newsletter =1 Link to comment Share on other sites More sharing options...
matpal Posted June 3, 2005 Author Share Posted June 3, 2005 Thanks very much. I found it in the control panel and sucessully exported it to Excel. Thanks again! Link to comment Share on other sites More sharing options...
wizardsandwars Posted June 3, 2005 Share Posted June 3, 2005 your actually got some pretty powerful information there at your disposal. For example, you can create a dynamic newsletter that will put an image and description at the top of the newsletter any prodcuts that the customer left in their cart! Kind of like a reminder of the product they didn't purchase from them. Maybe your could use it in conjunction with a 10% off coupon to entice them back to your store to buy it this time. The more you can personalize the newsletter for your customers, the better your response will be. ------------------------------------------------------------------------------------------------------------------------- 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...
matpal Posted October 31, 2005 Author Share Posted October 31, 2005 Ok...so I am trying to update this list again using the same exact method. Only this time when I download the information, it gives me an error message that the connection to the server has been reset. Everytime. Does anyone know what could be causing this and how to get around it? TIA. Link to comment Share on other sites More sharing options...
matpal Posted November 1, 2005 Author Share Posted November 1, 2005 Well, it is still happening today, so I dount it has anything todo with the server. any ideas???? 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.