#

Send success and error file attachments in one mail in a batch update

The mass update of the records is tricky in Salesforce org. You need to develop a batch to update the data in bulk. And yes, there are validation rules! Perhaps, some of your records are invalid or have formatting errors and Salesforce cannot update it, then it sends you an email. Now, if there are 120 chunks, it will send you 120 emails. 

120 is a big number! Managing these 120 emails with 120 CSVs is cumbersome and it frustrates the user. There is a dire need to consolidate these success files in one CSV and error files in another. 

So, we present you 5 steps using which you can send success and error file CSV attachments and send it in one mail for every batch update.

Here are the 5 Steps!

1. Make the batch stateful.

2. Declare global fields outside all methods.

3. Use Database.Update for DML and allOrNone parameter with a false value.

4. Iterate for loop while saving the results and if any record failed during the update.

5. Send an email with attachments in the finish block.

Source Code:

Try this piece of code out and let us know if you have any Issue. 

Happy Coding! 🙂

About the Author



Piyush Singhal

Co-Founder, Director | HIC Global Soutions | Salesforce Consultant | AppExchange Strategist

An outcome-oriented technology leader with a global outlook, Piyush has over 8 years of experience in Project Execution, SDLC Planning, Salesforce, CRM, Salesforce Mobile, and Force.com. Piyush, a seasoned

Salesforce professional, started HIC Global Solutions in 2015 after filling senior development positions at front-running company names in the Salesforce development industry. He looks forward to challenging Salesforce development tasks, delivering novel apps for AppExchange listings, and forging global partnerships through working with the passionate people.


About the Author



Piyush Singhal

Co-Founder, Director | HIC Global Soutions | Salesforce Consultant | AppExchange Strategist

An outcome-oriented technology leader with a global outlook, Piyush has over 8 years of experience in Project Execution, SDLC Planning, Salesforce, CRM, Salesforce Mobile, and Force.com. Piyush, a

seasoned Salesforce professional, started HIC Global Solutions in 2015 after filling senior development positions at front-running company names in the Salesforce development industry. He looks forward to challenging Salesforce development tasks, delivering novel apps for AppExchange listings, and forging global partnerships through working with the passionate people.