- \n
- We can send 100 emails per SingleEmailMessage<\/li>\n<\/ul>\n<\/li>\n
- Per day (24 hour) email limit\n
- \n
- We can send 1000 emails per day<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n
One point to note here that we can send unlimited emails to internal users including community users. More details on email limits can be found here<\/a>\u00a0(Salesforce governor limits)<\/p>\n
I have seen multiple questions on Salesforce developer community on how to resolve error related to sending email per 24 hour in Apex. Below solution has been used by me\u00a0for a long time and it is working to send thousands of email per day without any problem.<\/p>\n
Let’s see how we can resolve this error with below design.<\/p>\n
![\"Resolve](\"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/10\/Resolve-24-hour-Apex-email-limit-error-in-Salesforce.png?resize=435%2C545&ssl=1\")
<\/a>Resolve 24 hour Apex email limit error in Salesforce<\/figcaption><\/figure>\n <\/p>\n
Email tracking Custom Object<\/strong><\/p>\n
As we are talking about sending email from Apex code, that means it is very clear that we are ready for some coding. In this case as well, whenever we\u00a0want to send email , we will create a temporary record in email tracking object (Temporary Object). This object could be child of Object which\u00a0needs to\u00a0send email. You may or may not need this object, it completely depends on your project situation. Only reason we need object is to trigger workflow rule and have some basic informations like Email address of users to whom email should be sent. Same object can be used for reporting purpose as well to know how many emails are sent from Apex and who were recipient.<\/p>\n
Email recipients <\/strong><\/p>\n
This is tricky situation to resolve \u00a0and this might be step because of which this solution may not work for you. Basically, even from Apex email, we need to set recipients in Email. So, instead of setting recipients in Apex email we need to set email addresses of users in temporary custom object.\u00a0if we have many email recipients then we need to figure out maximum number of email fields in custom object and set email address in those fields. You may choose to have email field names as Email1, Email2 etc. We have limit of 500 fields in Enterprise and 800 fields in Unlimited edition anyway.<\/p>\n
So till now, we have a custom Object which have information about all email addresses which needs to receive Email.<\/p>\n
Use Workflow rule to send Emails<\/strong><\/p>\n
Now, we need to create a workflow rule on temporary custom Object saying “Whenever record is created” send email.<\/p>\n
Till this point you may not notice how powerful this approach could be and question may be popping up in your mind that off-course we know about Workflow rule and it was not solving purpose that’s why we used Apex approach. Well, you are right but we are yet not done.<\/p>\n
Unleashing Visualforce Email template hidden power<\/strong><\/p>\n
Whatever you can do with Apex, trigger, almost everything can be done in Visualforce email template. Again you may think that we cannot have apex controller behind it and therefore we cannot control much about output of Visualforce template. Not really; we have workaround here. We cannot have Apex controller for Visualforce Email template but we can have controller for Visualforce component and component can be easily embedded into template.<\/p>\n
![\"Visualforce](\"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/10\/Visualforce-Email-templates-to-save.png?resize=820%2C320&ssl=1\")
<\/a>Visualforce Email templates to save<\/figcaption><\/figure>\n Lets run by example so that it would make more sense. Whenever any new Contact is created , Send email to newly created contact with information about all related contacts exists for that\u00a0\u00a0Account.<\/p>\n
First we need to create Visualforce component, which will get AccountId and ContactId as input and display all related contacts in tabular format<\/p>\n
\r\nglobal class GetSampleAccount{\r\n\r\n public Id con {get;set;}\r\n public Id acc {get;set;}\r\n \r\n public Account accObj {get;set;}\r\n \r\n \/**\r\n * get all sibling Contacts\r\n *\/ \r\n public List<Contact> getAllContact(){\r\n \r\n \r\n if(acc != null)\r\n {\r\n accObj = [SELECT NAME FROM Account WHERE Id = : acc ];\r\n return [SELECT Id, Name, FirstName, LastName FROM Contact Where AccountId =: acc ];\r\n }\r\n \r\n return null;\r\n }\r\n}\r\n<\/pre>\nComponent Source code:<\/p>\n
\r\n<apex:component controller="GetSampleAccount" access="global" >\r\n <apex:attribute name="contactId" type="Id" description="Id of the Contact" assignTo="{!con}"\/>\r\n <apex:attribute name="accId" type="Id" description="Id of the Account" assignTo="{!acc}"\/>\r\n Below are all related Contacts of Account - <u> {!accObj.Name} <\/u>\r\n <table style="border: 1px solid black;border-collapse: collapse;">\r\n <thead> \r\n <th style="border: 1px solid black"> First Name <\/th> \r\n <th style="border: 1px solid black" > Last Name <\/th> \r\n <\/thead> \r\n <tbody>\r\n <apex:repeat value="{!allContact}" var="c" id="conRepeater"> \r\n <tr> \r\n <td style="border: 1px solid black" > {!c.FirstName} <\/td>\r\n <td style="border: 1px solid black" > {!c.LastName} <\/td> \r\n <\/tr> \r\n <\/apex:repeat> \r\n <\/tbody> \r\n <\/table>\r\n Thanks,\r\n Jitendra Zaa\r\n<\/apex:component>\r\n\r\n<\/pre>\nIn order to use any component in Visualforce template, its access must be “global”. We will be using above component in Visualforce email template. All heavy lifting is done in above Visualforce component and its controller class.<\/p>\n
To create Visualforce email template,<\/p>\n
- \n
- Search “Email Templates” in Quick find box.<\/li>\n
- Click “New Template”<\/li>\n
- Select type as “Visualforce”<\/li>\n
- In next screen, select folder where it should be saved.<\/li>\n
- Provide Template name<\/li>\n
- Select “Available for use” checkbox<\/li>\n
- In recipient Type, select “User”. It will not make any different to select any option because anyway email address will come from contact in my case and from temporary object in your case<\/li>\n
- In Related to dropdown, Select Object type from where merge fields will be used. In our case we are using Contact. However in many of cases as discussed above, it might be temporary object from where email will be initiated using workflow rules.<\/li>\n<\/ul>\n
![\"Creating](\"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2015\/10\/Creating-Visualforce-Email-Templates.png?resize=1012%2C662&ssl=1\")
<\/a>Creating Visualforce Email Templates<\/figcaption><\/figure>\n Click on “Save” button after all above steps. Now its time to edit template. Click on “Edit Template” and add below code<\/p>\n
\r\n<messaging:emailTemplate subject="Welcome to Account" recipientType="Contact" relatedToType="Contact">\r\n <messaging:htmlEmailBody >\r\n <c:ParentAccount contactId="{!relatedTo.Id}" accId="{!relatedTo.Account.Id}" \/>\r\n <\/messaging:htmlEmailBody>\r\n<\/messaging:emailTemplate>\r\n<\/pre>\nAnd we are done with template. Only part remaining is to create a Workflow rule to send this email template to any email field present in Contact or temporary email tracking object.<\/p>\n
How to send Visualforce page as an Email attachment<\/strong><\/p>\n
Sending attachment is also very easy. To send Visualforce as attachment, we need to use Component (move VF code to component) and embed it in “messaging:attachment” tag. You can refer this Salesforce documentation for sending attachment in Visualforce email template<\/a>.<\/p>\n
Lets say we want to send email and same email body should also be added as PDF file. We can change email template to look like<\/p>\n
\r\n<messaging:emailTemplate subject="Welcome to Account" recipientType="Contact" relatedToType="Contact">\r\n <messaging:htmlEmailBody >\r\n <c:ParentAccount contactId="{!relatedTo.Id}" accId="{!relatedTo.Account.Id}" \/>\r\n <\/messaging:htmlEmailBody>\r\n \r\n <messaging:attachment filename="relatedContacts.pdf" renderAs="PDF">\r\n <c:ParentAccount contactId="{!relatedTo.Id}" accId="{!relatedTo.Account.Id}" \/>\r\n <\/messaging:attachment>\r\n<\/messaging:emailTemplate>\r\n<\/pre>\nAs we can see in above code, we are using “messaging:attachment” tag of Visualforce email template. and content of that tag is again same Visualforce component. Read more about Visualforce Email template here<\/a><\/p>\n
Advantage of this solution<\/strong><\/p>\n
- \n
- Total email limit using workflow rule is 1000 x Total number of Salesforce\u00a0or\u00a0force.com user license.<\/li>\n
- It is hybrid solution where we are using Visualforce components but at the same time we are using Workflow rules which can add more actions on same transaction or switch ON – Off of functionality anytime<\/li>\n
- As you may create record (child record) each time so that workflow rule should execute, in that case you can have reporting capabilities as well. Currently there is no way to report on emails sent from Apex<\/li>\n
- You can capture other fields as well for reporting purpose<\/li>\n
- It also supports attachment which can have any dynamic content as discussed in this post<\/li>\n<\/ul>\n
Trade-off<\/strong><\/p>\n
- We can send 1000 emails per day<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n