As @Joe_Hewes indicated, the logic that you just described would work great as a formula. However, it could be simplified. Instead of looking to see if the field is empty, look for it to be full, and only output the desired text if that’s the case. The easy way to do this with an IF() function is using this syntax:
IF({Field Name}, "text block to output if the field is not empty")
This takes advantage of two IF() function shortcuts:
- A non-empty field is equivalent to
True (most of the time; the exception is a numeric field or any field returning a numeric value, where a zero make the field non-empty, but the value zero is equivalent to false), so literally comparing against an empty string or the BLANK() function is unnecessary.
- Omitting the third argument in an
IF() function will leave the field blank if the tested condition is false.
In the end, you would put that formula into its own formula field, then insert that formula field into your email template. If the formula outputs nothing, then the text block won’t appear in the email (it won’t even add an extra space). If the text block is created by the formula, it will be inserted into the email.
