|
jhoiland
Starting Member
36 Posts |
 Posted - March 10 2011 : 16:35:35
|
Hello,
You can pull this information directly from the database or you can do it easily in your cart admin as follows:
Login to admin and click on the Misc tab
Click on Query and Export
Select Table Newsletter and All fields
Click on Generate Query
For most queries you can also enter criteria...but this one struggles with the true false field datatype. You can either filter those that have opted out/unsubscribed in Excel or you can modify the query like this:
select * from newsletter where nletterauthorized = -1
The value for true will depend upon what database you are using...try -1 1 and 0 until you find the true subscribers.
Run Query or Export
You can also save it so you don't have to repeat all the steps next time around.
Best Regards,
JH
|
 |
|
All Forums
Where is my mailing list?
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
