[SalesForce] How to get Email Template executed body

I am working on sending email by using 3rd party application like Amazon SES

When i query for perticular email template i am getting body whaever the email templated had

like
Email Template body
Hello {!case.name}

I am retriving only above body not like executed body
Hello CaseName(records name).

As i got sence like without using case id how can it get name.

But i am wondering that how i need to send case id dynamically and how i can get executed body

Thanks in advance

Best Answer

I did something similar for previewing an email before it's being sent. The idea is to set up two emails in a list, one correctly and the other one not, try and send them and retrieve the generated email body in the catch statement:

Messaging.SingleEmailMessage[] previewEmails = new Messaging.SingleEmailMessage[]{};
Messaging.SingleEmailMessage firstPreviewEmail = new Messaging.SingleEmailMessage();
firstPreviewEmail.setUseSignature(false);
firstPreviewEmail.setSaveAsActivity(false);
firstPreviewEmail.setTemplateId(templateId);
firstPreviewEmail.setTargetObjectId(UserInfo.getUserId());
firstPreviewEmail.setWhatId(dealId);
previewEmails.add(firstPreviewEmail);
Messaging.SingleEmailMessage secondPreviewEmail = new Messaging.SingleEmailMessage();
previewEmails.add(secondPreviewEmail);
try {
    List<Messaging.SendEmailResult> previewResult = Messaging.sendEmail(previewEmails);
}
catch (Exception e) {
    generatedEmailBody = firstPreviewEmail.getHtmlBody();  // Email body generated
}

Related Solutions

[SalesForce] Using Batch APEX to generate template body dynamically with merge field values

Although the error says to commit or rollback before making the callout, and you are doing the rollback, SFDC seems to ignore this when the callout is executed - this could be because of batch context but I didn't have time to explore that.

OK, here are some ways to work around the error

Option 1 You will need two batchable classes and one custom object Deferred_Callouts__c.

Batchable class 1 - use the Database.savepoint - rollback sequence to get the rendered template. Then save the email recipient id and body in the custom object Deferred_Callouts__c. insert these all in the finish() method - which then invokes Batchable class 2
Batchable class 2 - Read all the Deferred_Callouts__c and construct the callouts

Considerations:

You are limited in the # of callouts so you'll need to be careful of limits in the batch size passed as scope.

Option 2 You will need one batchable class, one custom object Deferred_Callouts__c, and a workflow

Batchable class 1 - use the Database.savepoint - rollback sequence to get the rendered template. Then save the email recipient id and body in the custom object Deferred_Callouts__c. insert these all in the finish() method
Use a workflow that executes upon Create of Deferred_Callouts__c that uses an outbound message action to send via SOAP to the end point (assumes endpoint supports SOAP)

Option 3

You will need to use the Dan Appleman Async Framework as presented at Dreamforce that allows for unlimited async operations. This is well worth understanding.

This is my personal favorite as the solution is extensible to all your async needs over time

Option 4 Do what Alexander suggested and use the simulated merge field approach here . If you have formulas in the template, this will be difficult. This avoids altogether the DML operations.

[SalesForce] Send email using apex with merge fields from a custom object in the email template

You can do this by adding the messages, indivudually, to a list

List<Messaging. MassEmailMessage > messagesToSend = new List<Messaging. MassEmailMessage>();

        for (Id objectId : dataExtractRequestIds) {
            Messaging. MassEmailMessage mail = new Messaging. MassEmailMessage();

            mail.setTargetObjectIds(userIds);
            mail.setTreatTargetObjectAsRecipient(true);

            mail.setTemplateId(templateId);
            mail.setwhatId(objectId);
            mail.setSaveAsActivity(false);

            messagesToSend.adD(mail);
        }

        Messaging.sendEmail(messagesToSend);

You can absolutely pass a custom object.

a) Ensure your header looks like the one I put below (change the subject, of course)

<messaging:emailTemplate subject="the Sibject" recipientType="User" relatedToType="Data_Extract_Request__c">

b) Then, on your merge fields, use this notation

{!RelatedTo.Request_Title__c}

Best Answer

Related Solutions

[SalesForce] Using Batch APEX to generate template body dynamically with merge field values

[SalesForce] Send email using apex with merge fields from a custom object in the email template

Related Topic