Where are the email addresses and names of the people who opened sales tickets stored?

Is there a way to extract that list easily or do I need to go into the DB?

and where are they stored in the DB? I want to do a mailchimp campaign to all previous people who requested quotes through whmcs.

Thanks!

M

Is there a way to extract that list easily or do I need to go into the DB?

define "easily" ?

I don't think they'll be a way to do it from the admin area out of the box - you could write a report to generate the output and then use that to export the list to a csv file, but I suspect if you knew the SQL it would be easier to query the DB directly.

and where are they stored in the DB? I want to do a mailchimp campaign to all previous people who requested quotes through whmcs.

if they've opened tickets, it would be in tbltickets... I would imagine if they weren't existing clients (or logged in as such) when they submitted the ticket, then the 'userid' value will be 0 (any other value and they're existing clients)...

Ah yes, tbltickets it is! I was on sheet 1/3 on the tables in phpmyadmin duhh. thanks! I exported from phpmyadmin as csv.