VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-Cart StoreFront Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 VP-ASP 7.0 Questions
 Where is my mailing list?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

19 Posts

Posted - March 09 2011 :  22:13:37  Show Profile  Reply with Quote
When a person registers they can check 'Join our mailing List.' Where can i find this list in the admin pages? How can I export it to excel?

Starting Member

36 Posts

Posted - March 10 2011 :  16:35:35  Show Profile  Reply with Quote

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,


Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000