- Email Header -opening text at the beginning of the generated email.
- Email Body - expressions that include information from the data tables. The Body is placed between the Header and Footer when the email is generated, and repeated for each course in the registration group.
- Email Footer - closing text at the end of the generated email.
Items you can include in your Email templates:
You may include text strings in all 3 sections of your email template. For example:
- Opening messages in your Header (e.g. You have been successfully enrolled in the following:)
- Data labels (e.g. Registrant:, Course:, Location:) in the Body
- Closing messages in your Footer (e.g. contact info, refund policy).
You may include fields from the Course, Location, Names, NameUDFs, Register and RegUDFs data tables in your Email Body.
Fields must be delimited with the ## delimiter. For example:
IMPORTANT: you must convert numeric and date type fields to character expressions using functions such as Transform(), Str(), or Dtoc(). . For example, use the Transform() function to convert the registration fee amount into a character expression:
Variables must be delimited with the ## delimiter. For example:
- edates - displays course dates in text format (e.g. March 1 - May 10, 2021)
- edue - total due for registration in text format (e.g. 25.00)
- emember - displays Membership type and expiration date
- epaid - total paid for registration in text format (e.g. 25.00)
- eptype - display payment type (if any)
- ewkshop – displays workshop code and title for all workshops in which individual is enrolled
- eoptfees – displays any Additional Charges assessed to registration
- ebal - balance due for registration in text format (e.g. 25.00)
- erecpaid - date of payment, receipt number and amount
- epymsg - message stating either ‘Thank you for your payment’, or ‘Balance due X, please make checks payable to institution Y’
- prettyloc – displays formatted location information
For text type emails ONLY, you may use the crlf and cr2lf variables to insert line breaks (carriage returns) into your email body.
- crlf - inserts one line break (carriage return)
- cr2lf - inserts two lines line breaks (carriage returns).
Note, line break (carriage return) variables are not required in these new style templates. However, you may want to use them in iif statements to add line breaks (carriage returns) in your data. See the IIF Statements and Line Breaks (Carriage Returns) sections for more information.
You may use report functions that utilizes fields from the Course, Name, NameUDFs, Register, and RegUDFs data tables.
Functions must be delimited with the ## delimiter. For example:
You may use the IiF() function in your Email Body to display information only if the condition is true.
For example, use an Iif() function to show the Workshop label and workshop information if the registrant is enrolled in workshops for the course. If this is not a workshop type course--or if the registrant is not enrolled in any workshops, don’t display anything.
Note, your Iif() function statements must be delimited with the ## delimiter.
You may use line breaks in your Email template. For text type email templates, they will be preserved.
The line breaks will be preserved in the email:
Tip: check your note fields for trailing line breaks which will also be included in your email. For example, if your Location Information field has trailing line breaks, those will show in the email putting more (possibly unwanted) line breaks in your email.
Line Breaks in HTML Formatted Emails
You may also use line breaks in HTML formatted emails, for ease in reading ONLY.
See the HTML Formatted Emails topic for more information about HTML formatted emails.
You have a few options to include an Email Signature in your email Footer.
- Hard code the text into your Footer. For example:
- Use the Org Defaults fields (Data Structures > Organization Defaults). For example:
- Use the Email Signature field from your User record.
- ##EmSig## for text type emails.
- ##EmSigHTML## for HTML formatted emails.
Example (text type):
- Use the Include my Email Signature option on the Email screen:
Note, if you have the Include my signature (whenever I email) box checked on your User record:
the Include my Email Signature box will be auto-checked for you.
IMPORTANT: you cannot use options 1-3 with option 4. That will cause the email to have 2 email signatures.