How to get Email Template executed body

Question

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

Answer 1

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
}

Answer 2

Ok, I think this question has been asked many times ...how to get the rendered email template and save/use it somewhere.

And the answer is found here through a rather clever hack -- https://salesforce.stackexchange.com/a/8745/2602

Involves constructing the email and then doing a rollback to get the rendered value.