ehong33234 Posted February 12, 2008 Posted February 12, 2008 Hi, does anyone know of a way to export or extract all customer email addresses at once? It would be nice to have it available for export into an excel or text document. Thanks in advance!
burt Posted February 12, 2008 Posted February 12, 2008 Hi, does anyone know of a way to export or extract all customer email addresses at once? It would be nice to have it available for export into an excel or text document. Thanks in advance! SELECT `customers_email_address` FROM `customers` (use phpmyadmin if needed) http://www.w3schools.com/sql/sql_view.asp
ehong33234 Posted March 11, 2008 Author Posted March 11, 2008 burt, can you please elaborate on your post? Anyone else have a method? Thanks...
ehong33234 Posted March 11, 2008 Author Posted March 11, 2008 Well, found another way to extract or view all customer emails through the admin console in OSCommerce. Its definitely time consuming but do-able. Just go to TOOLS>Send Email and then right click on the page and click VIEW SOURCE. Scroll down to where all of your customer emails are and copy/paste them as needed. Now if there was only a way to extract emails from text files.... hmmmmm...
ehong33234 Posted March 11, 2008 Author Posted March 11, 2008 Okay, just answered my reply again. To export email addresses from text files, use this program: http://www.monkeyjob.com/FileMonk.html They've setup a preset script for extracting emails that you just have to load when the program opens. More info on this here: http://www.monkeyjob.com/FileMonk/FMExamp/...-From-Files.htm Goodluck.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.