How to view the outgoing emails stored in the database.
Running the following SQL script:
SELECT message.tps_date_sent "Date Sent",
recipient.tps_email_address "Sent To",
recipient.tps_is_email_sent "Email Sent"
FROM tps_user_message_recipient recipient,
WHERE recipient.tps_user_message_guid = message.tps_guid
ORDER BY message.tps_date_sent DESC;