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
Cristian_CociobanCristian_Cocioban 

Body is empty when sending email to a user from apex with Visulaforce email template

I want to send emails from apex, I'm using Visualforce email templates. This is my code:
  
EmailTemplate templateId = [Select id from EmailTemplate where DeveloperName = 'User_Template'];
OrgWideEmailAddress[] owea = [select Id from OrgWideEmailAddress LIMIT 1];

               	
for(User usr: users) {
    Messaging.SingleEmailMessage email = new Messaging.SingleEmailMessage();

    if ( owea.size() > 0 ) {
        email.setOrgWideEmailAddressId(owea.get(0).Id);
    }
			
    email.setSaveAsActivity(false);
    email.setSubject('Test Subject');			
    email.setTargetObjectId(usr.Id);
    email.setTemplateID(templateId.Id); 

    Messaging.sendEmail(new Messaging.SingleEmailMessage[] { email });  
}

Email template: 
<messaging:emailTemplate subject="Test" recipientType="User">
	<messaging:htmlEmailBody >
		this is a test
	</messaging:htmlEmailBody>
</messaging:emailTemplate>



It's sending the email but the body is empty. 

When sending from setup and using "Send Test and Verify Merge Fields" - it works - body is sent.

I've tried this: Sending Emails in Salesforce to Non-Contacts Using Apex . It throws an error a null reference error, I've checked in the log and the emailBody is null.

I've tried setting email.setWhatId(usr.Id);  - no change

The only solution that worked was building the message as string in apex and using email.setHtmlBody(someString);

However I'm curious of why using the template doesn't work, any help would be highly appreciated.
Best Answer chosen by Cristian_Cocioban
v varaprasadv varaprasad
Hi Cristian,

You need to query all fields in email template and assign those fields to messageing class like below.
  
EmailTemplate invTemplate = [ SELECT Id, Name, Subject, Body FROM EmailTemplate  WHERE Name ='emailtemplate name']; 
 
 string subject = invTemplate.subject;
 string body = invTemplate.body;
 
   Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
  mail.setSubject(subject);
  mail.setPlainTextBody(body);

Hope this helps you!

Thanks
Varaprasad
@For Support: varaprasad4sfdc@gmail.com


 

All Answers

AvaneeshAvaneesh
Hi 
if you are using setOrgWideEmailAddressId then Query in an OrgWideEmailAddress object and follow my code it is working for me​ 
OrgWideEmailAddress owa = [select id, DisplayName, Address from OrgWideEmailAddress limit 1]; EmailTemplate templateId = [Select id from EmailTemplate where name = 'Waitlisted opportunity now open']; List<Messaging.SingleEmailMessage> allmsg = new List<Messaging.SingleEmailMessage>(); Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage(); mail.setTemplateID(templateId.Id); mail.setSaveAsActivity(false); mail.setOrgWideEmailAddressId(owa.id); allmsg.add(mail); Messaging.sendEmail(allmsg,false);

 ​ please let me know if this was helpful

thank you 
Avaneesh Singh
v varaprasadv varaprasad
Hi Cristian,

You need to query all fields in email template and assign those fields to messageing class like below.
  
EmailTemplate invTemplate = [ SELECT Id, Name, Subject, Body FROM EmailTemplate  WHERE Name ='emailtemplate name']; 
 
 string subject = invTemplate.subject;
 string body = invTemplate.body;
 
   Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
  mail.setSubject(subject);
  mail.setPlainTextBody(body);

Hope this helps you!

Thanks
Varaprasad
@For Support: varaprasad4sfdc@gmail.com


 
This was selected as the best answer
Cristian_CociobanCristian_Cocioban
Thanks Varaprasad,  that was it!