Hi All,
I'm new to APEX. I have a requirement where I need to read a db table for list of email address based on a date column then send email to all those users whose data= today date.
I was able to create a scheduler in APEX by writing a select query to fetch data and put them in email template place holders and was able to send email successfully. But sometimes because of email ID issues or some other reasons email was not sent. And until I checked mail log table I was not able to determine if email was sent or not. Is there a way to identify once send method sends a mail to determine if it is successfull or not. Can someone please help me with that?
And even want to understand how to log those emails sent because not sure for how long data stays in mail log table.
Is there a way to write logs into custom tables for audit purposes.