How to extract all customer email from DB to txt / csv ?

[sammys2010]

Hello evertone.

I need to extract all customers email (for marketing purposes) into txt or cvs format.

How can do it in a fast way ?

 

thanks

[Muad'Dib]

Hello,

 

 

f you are using PS 1.5.x

 

BO > Advanced Parameters > SQL Manager.

 

Create a new rule with:

 

SELECT email from pss_customer

 

Note : replace pss_ by your own table prefix if different.

 

You are all set! Can be exported on screen or in CSV. Tada!

 

 

 

Hope this helps.

 

Cheers!