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?


2 Answers 2


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.


In magento 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.

Not the answer you're looking for? Browse other questions tagged or ask your own question.