function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ColbridgeColbridge 

How to send a list of failed record inserts in an email

P.S. No need to send entire record, just a few specific field on each failed records. Code so far is below:
  
Database.SaveResult[] srList = Database.insert(recsToInsert, false);

Integer successCtr = 0;
Integer failedCtr = 0;

for (Database.SaveResult sr : srList) {
    if (sr.isSuccess()) {
        successCtr ++;
    } else {
        // Operation failed, get all errors
        failedCtr ++;
        for(Database.Error err : sr.getErrors()) {
            System.debug('The following error has occurred.');
            System.debug(err.getStatusCode() + ': ' + err.getMessage());
            System.debug('Fields that affected this error: ' + err.getFields());
        }
    }
}
System.debug('Total successful record inserts: ' + successCtr);
System.debug('Total failed record inserts: ' + failedCtr);

 
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Colbridge,

Please find the below link which shows how to send email of the failed record using SingleEmailMessage.

http://deepikamatam.blogspot.com/2017/12/batch-apex-detect-failed-record-ids-in.html

If this solution helps, Please mark it as best solution.

Thanks