How to create a custom email template?

Email Template Creation

• I want to create an email template for custom object. It should display certain fields of the custom object depending on some conditions like the value of the city or country fields. How can I do this ?

• Answer:

  Take a look at creating a http://www.salesforce.com/us/developer/docs/pages/Content/pages_email_templates_intro.htm. Pay attention to the page on http://www.salesforce.com/us/developer/docs/pages/Content/pages_email_templates_with_apex.htm. From there: Create your custom controller: public class FindAccountsController { private final List<Account> accounts; public FindAccountsController() { // Query however you want, based on Country for example accounts = [select Name from Account where ShippingCountry = 'US']; } public List<Account> getAccounts() { return account } } Create your component: <apex:component controller="FindAccountsController" access="global"> <apex:dataTable value="{!accounts}" var="account"> <apex:column> <apex:facet name="header">Account Name</apex:facet> {!account.Name} </apex:column> </apex:dataTable> </apex:component> Create your template that then uses the component: <messaging:emailTemplate subject="Embedding Apex Code" recipientType="Contact" relatedToType="Opportunity"> <messaging:htmlEmailBody> <p>As you requested, here's a list of all our US accounts:</p> <c:AccountsComponent/> <p>Hope this helps with the {!relatedToType}.</p> </messaging:htmlEmailBody> </messaging:emailTemplate> To build the list of all fields dynamically (i.e., SOQL equivalent of SQL's Select *) take a look at http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_dynamic_describe_objects_understanding.htm and http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_dynamic_soql.htm. You could use a http://www.salesforce.com/us/developer/docs/pages/Content/pages_dynamic_vf_field_sets.htm if you want a subset of all of the fields. The beauty of this approach is it allows your admins (non devs) to maintain the application you build through clicks and not editing your Visualforce directly. Here's an http://www.salesforce.com/us/developer/docs/pages/Content/pages_dynamic_vf_field_sets.htm that builds a SOQL query from a Field Set and then displays the results in a component. public class MerchandiseDetails { public Merchandise__c merch { get; set; } public MerchandiseDetails() { this.merch = getMerchandise(); } public List<Schema.FieldSetMember> getFields() { return SObjectType.Merchandise__c.FieldSets.Dimensions.getFields(); } private Merchandise__c getMerchandise() { String query = 'SELECT '; for(Schema.FieldSetMember f : this.getFields()) { query += f.getFieldPath() + ', '; } query += 'Id, Name FROM Merchandise__c LIMIT 1'; return Database.query(query); } } And component: <apex:component controller="MerchandiseDetails"> <apex:form > <apex:pageBlock title="Product Details"> <apex:pageBlockSection title="Product"> <apex:inputField value="{!merch.Name}"/> </apex:pageBlockSection> <apex:pageBlockSection title="Dimensions"> <apex:repeat value="{!fields}" var="f"> <apex:outputField value="{!merch[f.fieldPath]}" </apex:repeat> </apex:pageBlockSection> </apex:pageBlock> </apex:form> </apex:component>