Sending email using TI process

[dilip]

I need a sample code or any URL to send email using TI process....Please help me on this learning part.

I have an attachment of file,smtp servername...but dont know the procedure to write ...

[jim wood]

Did you try to search here or even google this? There are at least 5-10 threads that cover this is great detail on this site alone.

[dilip]

Yes I googled..But not reaching the exact code what i need..I am getting in bits...sometimes i get email notification configuration..which i dont need....sometimes so much lenghty code which is difficult to understand for me. Iam beginner..

[jim wood]

There is no email function within TM1. You have build something in from outside. That is why the code may seem a little on the complicated side.

[dilip]

I got this link http://www.tm1forum.com/viewtopic.php?f ... 4....other than this ...

[dilip]

arguments = 'CScript C:\sendMailOther.vbs '|sSMTPSvr |' ' | sSender | ' "'|pRecipient|'" "'|pSubject|'" "'
| sFileName | '"' ;
ENDIF;


I got this code but here what is "sendMailOther.vbs" which is confusing me...pls help

[declanr]

Earlier in the same post is the vb script which needs to be set up.

If you are struggling with that go the easier route and download something like sendmail.exe or BLAT; then all you have to do is pass parameters to the executable.

[rmackenzie]

If you are struggling with that go the easier route and download something like sendmail.exe or BLAT; then all you have to do is pass parameters to the executable.

Nowadays, the Powershell option is much easier as it is a default install for a modern Windows OS and has in built e-mail capabaility that is easily accessible from a few lines of TI. With this method there's no need to manage separate executables or scripts and their locations etc. E.g.:

Code: Select all

sFrom = 'tm1@yourcompany';
sTo = 'robin.mackenzie@somewhere.com';
sSubject = 'test';
sBody = 'test';
sSmtpServer = 'name of your smtp server';

# build powershell command
sPsCmd = '"& {
Send-MailMessage 
-From ' | sFrom | ' 
-To ' | sTo | ' 
-Subject ' | '\"' | sSubject | '\"
-Body ' | '\"' | sBody | '\"
-SmtpServer ' | sSmtpServer | ' 
}"';

# execute command
ExecuteCommand ( 'powershell.exe -command ' | sPsCmd, 1 );

[declanr]

Nice and straightforward; I like it.

[dilip]

Thanks everyone on this post...I was able to do via TI process...using sendmail.exe....and it worked..
This powershell I have done already..I have done in my last project using powershell,but I was learning to do via TI processs.

[declanr]

This powershell I have done already..I have done in my last project using powershell,but I was learning to do via TI processs.

RMackenzie's powershell solution would still be called from a TI process; and its the same concept with sendemail.exe where you are relying on something external to TM1 and passing pretty much the exact same parameters - so the amount of "TM1" involved in either would be approximately the same.

[dilip]

Is it declanr!!.....Then I will try definately using powershell with TI process Thanks...This will be good idea...

Thanks Rmackenzie and declanr