Where to find sent emails list

Hello,
as per topic title, can anyone suggest where I can find the list of all sent emails by system?
To be more detailed, I wrote a job for the scheduler module that send one email for each customer and after email has been sent, it creates an Email bean saving all informations about the email sent.
Where I can find a list of all sent Email beans?
Any help is appreciated. Thank you.

Hey there,

As far as I’m aware, there’s not a clean list of all Emails sent from the CRM
(Though, someone please correct me if i’m wrong!)

There might be some ways to get the info though


CRM-side, you would be able to view Emails sent to the specific records themselves, via the “History” subpanel:


From the Database, you could run a Query on the Emails table to retrieve all Sent/Outbound Email records.
Such as:

SELECT * FROM `emails` WHERE `type` LIKE 'out' OR `status` LIKE 'sent' ORDER BY `date_entered` DESC 

You might also be able to grab similar results via code, using the “get_full_list()” function when working with Beans:https://docs.suitecrm.com/developer/working-with-beans/#_get_full_list
This should allow you to grab all Email beans, filtered down by conditions


Hopefully something above can point in the right direction!