Hi, You need to create a Visualforce Template type email template for this. In the same, then you can create Apex:Datatable or simple html table. Remember: style classes does not work in email template, for this use inline style classes thoughout the html.
Hi guys, Anybody help me to write this batch? I'm new on salesforce. Thanks !
1. Create a batch class that summarizes all Opportunity Amounts for each Account; 2. An email should be sent to the primary contact of all Accounts, containing a table with the Closed Won/Open/Closed Lost summarized Opportunity Amounts; 3. Schedulable class that calls the batch class should be created; 4. The class should be scheduled from the Developer console. Please provide script to schedule the job daily at 10:00 AM, once a week (Friday at 1:00 PM), once a month(Last Friday of the Month at 6:00 PM).
You need to create a Visualforce Template type email template for this. In the same, then you can create Apex:Datatable or simple html table.
Remember: style classes does not work in email template, for this use inline style classes thoughout the html.
Thanks,
Ashish Garg
1) https://developer.salesforce.com/page/VisualForceEmailTemplates_sample
I hope below will help you
1. Create a batch class that summarizes all Opportunity Amounts for each Account;
2. An email should be sent to the primary contact of all Accounts, containing a table with the Closed Won/Open/Closed Lost summarized Opportunity Amounts;
3. Schedulable class that calls the batch class should be created;
4. The class should be scheduled from the Developer console. Please provide script to schedule the job daily at 10:00 AM, once a week (Friday at 1:00 PM), once a month(Last Friday of the Month at 6:00 PM).