Does Magento 1 log transactional mails that were sent?

Question

Can you view the automated transactional emails that have been sent by the system like order confirmations, password forgotten-mails and more? Is there some kind of a mail log which you can view afterwards?

Answer 1

The new 1.9.1 Email System leverages two database tables to queue, process, and log transactional order confirmation emails sent after customers checkout:

1. core_email_queue This stores data relating the emails that are sent for order confirmations
2. core_email_queue_recipients - This stores the email addresses of the recipients of the emails stored in core_email_queue

Troubleshooting issues with this new functionality can be difficult. The link above is fairly technical but covers the key areas. I also have had success with following this process in my own troubleshooting, though the issues I ran into were specific to my environments so your mileage may vary.

Answer 2

In magento 1.9.1.0 there is email queue table. In previous magento versions most probably you can find only was email sent or not. In tables sales_flat_* (order/invoice/shipment) there is such field as 'email_sent'. Which has only true/false value. The email address you can also find in same table.