View Newsletter Subscribers??

[Kokopelli]

I would like to do a drawing for prizes for my newsletter subscribers each month. I have looked everywhere and can't seem to find where to actually VIEW my newsletter subscribers name and email. Can anyone tell me where to find this info please?

Thanks so much,

Jessi

[Chuckl]

If you have the Newsletter only mod installed, it adds a Subscription manager dropdown in Admin-Customers which lists all subscribers.
Otherwise, the standard Zen Cart install has an 'All Newsletter Subscribers' option in the Audience Select dropdown in Send Email and Newsletter Subscription manager, which means that there is an SQL query defined for it in the query_builder table in the database - i.e.

select customers_firstname, customers_lastname, customers_email_address from TABLE_CUSTOMERS where customers_newsletter = '1'

If you have the subscription mod installed, the query is slightly different.

[DrByte]

To add to Chuckl's post, the Email Address Exporter tool found in the Downloads area is very handy for viewing the information you're looking for. It can be used to export your subscribers list to common formats, or just to view it on-screen (HTML mode).
It uses the query_builder table mentioned earlier to determine which information you want to view when you choose the particular group from the pulldown list it offers.