Search Forum Home   DotNetNuke  CATALooK.netStore  "Special O...  "Special Offers" checkbox    3/8/2010 9:34:25 PM SCI-116637 14 posts "Special Offers" checkbox Where is the information stored for the checkbox that says "I want to receive information and special offers"? I wish to export the list of customers who checked this box so I can send them email from our email marketing tool. The best I've found so far is the list in CAT_EmailBlockList of addresses who do not wish to receive communications.  3/10/2010 2:18:39 AM host 1831 posts Re: "Special Offers" checkbox To display all blocked email addresses execute: select * from cat_emailblocklist via Host -> SQL To display all not blocked email addresses, execute this code: select email from users where email not in (select email from cat_emailblocklist)  Page 1 of 1   DotNetNuke  CATALooK.netStore  "Special O... Flat View Tree View Oldest To Newest Newest To Oldest