Sending Emails from TM1 (Part 2: HTML)

Sending Emails from TM1 – Using HTML

Problem:

Although some additional components of TM1 have built-in email functionality, TM1 does not have email functionality built into its ETL Engine. Text emails will not suffice, you want to employ HTML encoding in your email to provide a more ascetically appealing email.

Solution Process:

  1. Within a TI Process output text to a file to be used as the body of the email to be sent.
  2. Execute a email script command to send off the email to recipients.

Executing the TI script:

Email script is parameter driven and will prompt you for parameters to be pushed into the TI process:

  • pRecipient : [email protected] ; [email protected] ( note use a  semi column between each email address when emailing multiple users.
  • pSubject:  add a comment.
  • pBody: add a comment .
  • pAttachFile: file location of where your file attachment resides.

Email script global variables will need changing before execution of script:

  • sFileName: file location of generated txt file used as the body of the email to be sent.
  • sSender: [email protected] ( who the email is from)
  • sSMTPSvr: SMTP or Exchange Server used for emailing. This is often SMTP.yourCompany.com.au ( SMTP server )

Solution:

Screenshot of Email: (TM1EmailHtml.zip)

HTML Email alert

Notes:

  • Due to 255 character limit restriction within TM1 (prior to version 9.4), instead of emailing individuals you should set up a email group instead of separating each email address separately i.e. use [email protected] instead of [email protected] ; [email protected]

You might also like