How to get the Opportunity Contact Role details in Salesforce Email Template?
This is not possible in normal email template Text or HTML (using Letterhead) or Custom (without using Letterhead).
Its possible using the Visualforce Email Template.
Salesforce Email Template Types
Visualforce Email Template:
[html]
<messaging:emailTemplate subject=”Opportunity Contact Role Information” recipientType=”User” relatedToType=”Opportunity”>
<messaging:plainTextEmailBody >
Hello,
This is testing the text section….
Opportunity Name: {!Relatedto.name}
Account: {!Relatedto.account.name}
Amount: {!Relatedto.amount}
Contact Roles for this Opportunity:
<apex:repeat value=”{!RelatedTo.OpportunityContactRoles}” var=”ContactRole”>
{!ContactRole.Contact.Name} – ({!ContactRole.Role}) {!ContactRole.Contact.Email}
</apex:repeat>
Thanks!
</messaging:plainTextEmailBody>
</messaging:emailTemplate>
[/html]
OpportunityContactRole Object Field Details: