Are you trying to send an email using an SQR? is that what you mean by "trigger"?

I have done this only once and used a unix command to call an email script. the unix commad looks like this:

Hi..

I got the whole code for this.And it works.

BEGIN-PROCEDURE sendmail
let $subject = 'Subject of the Email Here'
let $to_list = 'email@email.com'
let $ReportID = 'G:\PeopleSoft\Reports\Report_Name.pdf'
let $alias ='Attachment File Name Alias including the file extension'
let $enter = chr(10)chr(13)
let $body_txt = 'Hi,'$enter$enter'Please Find the Report attached with this email.'$enter$enter'Regards,'$enter 'Peoplesoft Application Support'$enter$enter'PS: We request you not to reply to this automated mail trigger.' let $mail-cmd = 'F:\PSFT819\bin\server\winx86\psmail -TO"'$to_list'" -SUBJECT"'$subject'" -BODY"'$body_txt'" -FILE"' $ReportID '" -ALIAS"'$alias'"'
CALL SYSTEM USING $mail-cmd #Status
end-procedure

Warm Regards,
P I Y A L I

I tried usin the procedure in my sqr ,but on execution ,it is giving some errors..lik:its not recoznizing the $mail-cmd -invalid variable or function name

Hi Chandan,
The script above points to the psmail that is located "'F:\PSFT819\bin\server\winx86\psmail", but this might not be the case in your situation.

You should mention the exact path for the psmail.exe in your app server.
Change the code according to your environment and requirement.

Thanks,

Ashar

Hi All ,
First of all thanx for the responce ..........act before execution ,I had changed the path to psmail.................

Thnxs again...........

Hi Im trying to send an email with an attachemnt...

The attachment was posted to the psreports folder in webserver.
But my code are pointing to the appserver... pls help...

let $enter=chr(10)
let $EMAIL='Naalera.MohdYaacob@acs-inc.com'
Let $File = '/opt/vendor/psoft/pt846/psreports/CBPSMYDV/20090707/44814/cbniceni_04.pdf'
let $BODY = 'Hi Attach is the Civil Union Report.'

let $system_command ='psmail -TO"'||$EMAIL||'" -SUBJECT"Civil Union'||'" -BODY"'||$BODY||'" -FILE"' ||$File||'"'
Call system using $system_command #call_status

Above path '/opt/vendor/psoft/pt846/psreports/CBPSMYDV..... is ponting to appserv instead of webserver.. how to change to web server...

Hi P I Y A L I,
Thank you for your code share.

Warm Regards,
Peter.Wan