How can I get a listing of emails?

[Guest]

Fairly simply question I hope....

 

Is it possible to obtain a list of our registered customers email addreses? Without manually going into each one. i.e preferably a text file or csv file with each one.

 

Thanks.

[germ]

Search the contributions.

 

There are several available.

 

I haven't tried any.

 

One that might work:

 

Customer Export

[cleveland-jay]

That is pretty easy. Connect to your store's database manually. (I usually just open an ssh connection to mine and issue a 'mysql -u <myuserid>...(etc)' command. You may have a different mechanism.)

 

The query you'd want is:

 

select customers_email_address from customers into outfile 'myoutput';

 

Or you can get fancier and ask:

 

select customers_firstname, customers_lastname, customers_email_address from customers into outfile 'myoutput';

 

which would tell you who the email actually belonged to. The filename in the single quotes can be whatever you want it to be. It will place it somewhere under your mysql library path. Mine end up in /var/lib/mysql/osCommerce.

 

You can also specify what to use for a field delimiter after your filenames, but the exact syntax of that escapes me at the moment. Without specify delimiters, you get lines with fixed length fields padded with spaces.

--

Jay