RE: [sqr-users] Sending email with Attachment from NT

["Kloprogge,Frank F.J.M." <F.J.M.Kloprogge@fontys.nl>]

Hi Amit,

You were close, you missed the " around the filename

So the full command is psmail -TO"someone@somewhere" -FROM"me@here"
-SUBJECT"my subject" -BODY"Hi guys"
-FILE"c:\temp\teadme.txt;c:\temp\info.doc" -ALIAS"readme.txt;info.doc"

So you're line should look like:


let $email_cmd = 'psmail -TO"'||$address||'" -SUBJECT'||$subject||'"
-BODY"'||$body||'"' ||' -FILE"c:\temp\readme.txt"'

BTW excerpts from peoplesoft:

PSMAIL.EXE looks for the environment variable PS_SERVER_CFG to retrieve
its 
SMTP Settings.  That variable is usually set on the Application Server
and Process 
Scheduler on boot up.  On the Application Server, it usually is set to 
%PS_HOME%\appserv\<domain name>\psappsrv.cfg.  On Process Scheduler, 
it usually points to %PS_HOME%\appserv\prcs\<database name>\psprcs.cfg. 

The possible command line arguments are: 
TO = the recipients of the email 
CC = carbon copy list of recipients 
BCC = blind carbon copy list of recipients 
FROM = the sender of the email 
SUBJECT = the subject heading of the email 
BODY = the email body 
FILE = list of file attachments to send with email.  File location is
relative to where  PSMAIL.EXE is run from. 
INPUT=points to a config file that contains the above seven arguments.
This    was to bypass the maximum number of characters allowable on a
command         line and carriage return/line feeds. 

The tokens - or / can be used in front of the above arguments.  The
values for each argument must be encapsulated in double quotes.  Look at
the following examples. 

Sample usage: 
PSMAIL -TO"rob_smith@abct.com" -FROM"SystemTest_InvRpts@abc.com"
-SUBJECT"Daily Inventory Report(s)" 
PSMAIL /TO"edward_jones@abc.com" /FROM"HR@abc.com" /SUBJECT"Time Out
Reporting" /BODY"Please report any PTO for the month of March." 
PSMAIL /INPUT"demo1.txt" 

The content of the file, "demo1.txt" is as below: 

-TO"lisa_harper@abc.com;Robert_thomas@abc.com"
-FROM"SystemTest_InvRpts@abc.com" -SUBJECT"System Test Daily Inventory
Report(s)" -BODY"Here is the report(s) you requested. (Both A & B
Databases)"
-FILE"d:\temp\ps\e800r20\in_bu_bal_A.out;d:\temp\ps\e800r20\in_bu_bal_B.
out" 

If you are using -INPUT or /INPUT then you need to have the input file
in UNICODE format. 
(On NT, you can do this by saving the file in notepad as "unicode
format" & on Unix you can run the following PeopleSoft binary file:
PSUNICONV ASCII <inputfile> UCS-2 <outputfile>)

HTH

Frank.



-----Oorspronkelijk bericht-----
Van: sqr-users-bounces+f.j.m.kloprogge=fontys.nl@sqrug.org
[mailto:sqr-users-bounces+f.j.m.kloprogge=fontys.nl@sqrug.org] Namens
Amit Kedia
Verzonden: maandag 20 maart 2006 18:46
Aan: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Onderwerp: RE: [sqr-users] Sending email with Attachment from NT

Hi Frank,

Can you please send me the syntax because when I try using, it doesn't
work.

let $email_cmd = 'psmail -TO"'||$address||'" -SUBJECT'||$subject||'"
-BODY"'||$body||'"' ||' -FILE c:\temp\readme.txt'

Thanks
amit

-----Original Message-----
From: sqr-users-bounces+a.kedia=surewest.com@sqrug.org
[mailto:sqr-users-bounces+a.kedia=surewest.com@sqrug.org] On Behalf Of
Kloprogge,Frank F.J.M.
Sent: Sunday, March 19, 2006 11:48 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Sending email with Attachment from NT

Hi,

The options you can use for psmail are:

-FROM, -TO, -SUBJECT, -BODY, -FILE, -ALIAS and -INPUT

-INPUT is used in case the commandline is too long. 
-ALIAS is used to create a short name for the file being attached,
otherwise the receiver gets the complete path/filename

One small problem might arise because I found out that on Windows 2003,
psmail expects UCS2 as characterset.

HTH

Frank.


-----Oorspronkelijk bericht-----
Van: sqr-users-bounces+f.j.m.kloprogge=fontys.nl@sqrug.org
[mailto:sqr-users-bounces+f.j.m.kloprogge=fontys.nl@sqrug.org] Namens
Amit Kedia
Verzonden: vrijdag 17 maart 2006 20:21
Aan: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Onderwerp: [sqr-users] Sending email with Attachment from NT

Hello All,

Has anyone sent an email with an attachement from SQR on NT. The
following works except I do not know how to send an attachement. 

let $email_cmd = 'psmail -TO"'||$address||'" -SUBJECT'||$subject||'"
-BODY"'||$body||'"'

call SYSTEM using $email_cmd #status nowait


Your help is appreciated.

thanks
amit


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


----------------------------------------------------------------
Op deze e-mail zijn de volgende voorwaarden van toepassing:

http://www.fontys.nl/disclaimer

The above disclaimer applies to this e-mail message.
----------------------------------------------------------------

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


----------------------------------------------------------------
Op deze e-mail zijn de volgende voorwaarden van toepassing:

http://www.fontys.nl/disclaimer

The above disclaimer applies to this e-mail message.
----------------------------------------------------------------

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users