[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Sending E-mail from SQR
- Subject: Re: [sqr-users] Sending E-mail from SQR
- From: Charly Lebrun <calebrun@yahoo.com>
- Date: Sun, 25 Apr 2004 22:57:06 +0200 (CEST)
- Delivery-date: Sun, 25 Apr 2004 15:58:14 -0500
- In-reply-to: <s07bcbb5.026@mail.alegent.org>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
--- Harry R Harris <HHARRIS@alegent.org> a écrit : > I am trying to send an
email from within an
SQR using the following:
>
> let $mail_cmd = 'echo' || $body || '|' || ' mailx -s ' || $subject ||
> $address
>
> call system using $mail_cmd #status nowait
>
> Seems to work fine until $body contains more than about 500
> characters.???
>
> We are: SQR for PeopleSoft/8.19/IBM RS6000/AIX 5.1/Oracle 9.2.0.4
>
>
Hello
You can try to produce an ASCII text file from SQR (open-file, etc...) then
send it with something
like (suppose you named you text file 'email-text.txt') :
let $mail_cmd = 'cat email-text.txt |' || ' mailx -s ' || $subject || $address
call system using $mail_cmd #status nowait
Here you should not reach the 500 char limit...
Hope this helps,
Charly
=====
Charly Lebrun
calebrun@yahoo.com
_________________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users