Marc_J Posted October 5, 2006 Posted October 5, 2006 For a variety of reasons I'm using 3rd party mailing list software, and I want to periodically export the list of people who have ticked the Newsletter box in my store's create account page. I need to generate a page which lists, one per line, the email addresses of those customers. Nothing fancy, just a list of addresses which I can copy and paste! I'm guessing this is a very simple (for someone else) database query and output - but I don't know how? All I know is that I'm looking for "customers_newsletter" in table "customers" to equal "1" and if so echo "customers_email_address" for each one! I'll also have to remove the "Newsletter Subscriptions" part of the account maintenance section, as removal will be through a link in emails sent out. osC won't be able to update the subscribers list if customers attempt to unsubscribe through their osC account. But that part I can manage myself! Can anyone point me in the right direction re listing subscribers on a page?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.