Ask Question
Help Others
Home › Blogs › Ashar's blog

Send Emails in SQR

Mon, 03/31/2008 - 12:24pm — Ashar
Your rating: None Average: 4.4 (9 votes)

Here is the piece of code you can use to send email with attachments in SQR.

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

You would have to change the value of the variable $mail-cmd based on th path of your PS_HOME.

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.
Tue, 04/15/2008 - 5:50am
#1
Feby's picture
Feby (not verified)
Good work man..

Good work man.. keep it up..
Post some articles related to peoplesoft server administration.
Feby

Top
Tue, 10/06/2009 - 2:51pm
#2
Guest's picture
Guest (not verified)
Re: Send Emails in SQR

is there a flag or switch that can be set so that the users are unable to reply to the email once it is received?

Top
Wed, 10/07/2009 - 6:47am
#3
Lepa's picture
Lepa
User offline. Last seen 2 years 14 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Send Emails in SQR

Quote:
is there a flag or switch that can be set so that the users are unable to reply to the email once it is received?

Nope, you can't prevent the user from hitting the reply button.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Top
Wed, 10/07/2009 - 2:32pm
#4
Guest's picture
Guest (not verified)
Re: Send Emails in SQR

On the -TO parameter, I want to use a file that list several email addresses, what format do I use? I have them currently listed and it only sends to the first one.

Top
Wed, 10/07/2009 - 2:35pm
#5
Dee's picture
Dee (not verified)
Re: Send Emails in SQR

Thanks. Let me re-phrase - is there a way to flag the sent email such that when the user attempts to reply, the reply will not route?

Top
Wed, 10/07/2009 - 8:05pm
#6
Lepa's picture
Lepa
User offline. Last seen 2 years 14 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Send Emails in SQR

Can't you use an invalid "from" email? What you happen if you tried to do that? Please, lets use the post on the forum to finish this up http://compshack.com/forum/peoplesoft/peoplesoft-technical/sendmail-do-not-reply

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Top
Fri, 09/19/2014 - 2:34am
#7
Guest's picture
Guest
Re: Send Emails in SQR

how to send multiple attachments through sqr , we need to send excel file also

Top
Fri, 09/19/2014 - 3:24am
#8
Guest's picture
Guest
Re: Send Emails in SQR

we need to attach both excel and pdf .. is that is possible .. request any one over here to help me ou t... thanks in adavnce ..

Top
Mon, 07/13/2015 - 5:41am
#9
Guest's picture
Guest
Re: Send Emails in SQR

How to send mail people in keeping CC

Top