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:

<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>

OpportunityContactRole Object Field Details:

Written by 

2x Salesforce MVP | Platform Champion | 18x Salesforce Certified | MuleSoft Certified | 8x Trailhead Ranger | TechForce Services | Sydney | Australia

Leave a Reply

Your email address will not be published. Required fields are marked *

*