We are experiencing issues with the mailbox we use as SMTP Server (hitting the maximum sent emails per day on Microsoft exchange)
Currently I have a report created on the sys_email_log for and filtered by "type=sent"
Is there a way to produce a report on count the recipients field?
I do not believe there is an out of box dashboard or report that provides number of recipients for sent emails. You can create a custom field that tracks this information and report on it.
Below is a sample email with multiple recipients
You can create additional field to store the recipient count and calculate this information and use 'SUM' function on this field
By default, email sent to stakeholders are stored in 'recipients' field. If there are email templates where cc and bcc are used, they are stored in 'copied' 'blind_copied' fields and above logic can be extended to include the count for those fields as well.
I hope you appreciate the efforts to provide you with detailed information. If my response helped to guide you or answer your query, please mark it helpful & accept the solution.
Thanks,
Bhuvan
