FiercePhish is a full-fledged phishing framework to manage all phishing engagements. It allows you to track separate phishing campaigns, schedule sending of emails, and much more.
Here's a MySQL statement I use to export a list of emails from the db:
SELECT emails.subject, emails.sent_time, emails.uuid, target_users.first_name, target_users.last_name, target_users.email FROM emails INNER JOIN target_users ON emails.target_user_id=target_users.id INTO OUTFILE '/var/lib/mysql-files/Phish_Users.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Here's a MySQL statement I use to export a list of emails from the db:
SELECT emails.subject, emails.sent_time, emails.uuid, target_users.first_name, target_users.last_name, target_users.email FROM emails INNER JOIN target_users ON emails.target_user_id=target_users.id INTO OUTFILE '/var/lib/mysql-files/Phish_Users.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';