3 Salesforce Tips to Save you Time: Part 3

By Darren Starr

Welcome back for our third and final Salesforce tip to save you time. These are tips from the insiders: the StarrData team! Last week we taught you how to create a dynamic report link, and the week before we shared a little-known tip about creating a secret tab.

For our final tip, our team would like to share with you a way to save you time while creating mass emails.

Tip #3: Using Formulas in Email Templates:

If you are sending a marketing email but would like it to say statement a if a certain statement is valid about the recipient, and statement b if that statement is false, you can send one email to achieve this.

By using formula functions like (IF, CONTAINS, CASE & TEXT) within an email template you can create some basic logic. For example, if you want the email to contain a statement if the value of one field equals True, but another statement if the same field equals False.

First, create an email template as normal. (Text or HTML)
Create the formula as you would for an actual Formula field, Validation Rule, or Workflow.
1. Just make sure that the formula is between “{!” formula goes here “}”.
Now place the following formula where you want it to show up on the template. The formula will look something like this. {!If(Object.FieldName__c, “This is a true statement”, “This is a false statement”)}
Save your email template.
Make sure you test the new email template to ensure the formula is working correctly, before sending it out to an actual recipient.