We have enabled "Show Opt In" according to:

"Show Opt In - Check this box if you would like to display the user opt in checkbox and 
message to your customer during checkout. If the “Show Opt In” checkbox is not 
checked then opt in checkbox and message will be hidden. If the user opts in during 
checkout a “True” value will be stored in the database for this customer. It is a good idea 
to check this box if you would like to engage your customers using email marketing. 
When you require the user to check the “Opt In” check box, it makes you CAN-SPAM 
compliant and helps you win chargeback disputes if they arise. "

Where can we go to export a list of customers who have opted in?  

Thanks

Hi Mike,

The Opt In checkbox is saved as a bit field in the Smith_Customer table in the "Contact" column. You can get a list of all customers who have opted in by running the following SQL Statement:

SELECT * FROM Smith_Customer
WHERE Contact=1;

Hope this helps!