Revision of send email/attachments from Wed, 2007-01-10 14:35

It is possible to send email alerts or reports as attachments from Turbo Integrator. This can be achieved by executing a VB script.

1. save the attached VB script on your TM1 server
2. create a TI process
3. in Epilog add the following code:

S_Run='cmd /c D:\path\to\SendMail.vbs smtp.mycompany.com 25 tm1@mycompany.com me@mycompany.com "Today report" "check it out" E:\TM1Reports\todaysreport.xls'
ExecuteCommand(S_Run,0);

The syntax is:
SendMail.vbs server port sender destination subject body attachment
so replace the fields as required to suit your setup

/!\ The DOS command line is limited to 255 characters so avoid putting too much information in the body.
/!\ If a field contains a blank space you must enclose that field in quotes so the script gets the correct parameters

code from kc_kang (applix forum) and http://www.rondebruin.nl/cdo.htm

Bookmark/Search this post with:

| | | | | | | |