Skip navigation.
spilling the beans

send email/attachments

developers
| | |

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



Applix is developing a tool called "Report Connect" currently in the beta stage, which will integrate with TM1 and allow users to schedule automated reports emailing from the TM1 server


Average rating
(1 vote)
AttachmentSize
SendMail.vbs891 bytes