Re: Mailing SQR report from unix

[Kimberly Lawrence <Kimberly_Lawrence@CCNOTES.CCITY.COM>]

Liz,

I've been using this command issued from several SQR's for months now with no
problems.  I've even used the command to send an email with multiple
attachments.  No problems.

(echo " Text to appear in body of email.\n\n";uuencode
/directory/name_of_file_to_attach
name_of_attachment_as_it_should_appear_in_the_email) | mailx -m -s "Subject line
 text" -r "who the email is from"
email_address

I guess yours would look something like this:

(echo " \n\nAttached is the report that you requested.\n\n";uuencode letter.htm
letter.htm) | mailx -m -s "SQR report you requested" -r "System Name"
lkarimundackal@jhancock.com

Feel free to contact me directly if you need any help getting this to work.





 (Embedded
 image moved   "Karimundackal, Liz J."
 to file:      <lkarimundackal@JHANCOCK.COM>
 pic16404.pcx) 07/09/99 10:19 AM




Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Kimberly Lawrence/MIS/Circuit City)
Subject:  Mailing SQR report from unix




Hi all,
        I am trying to mail the report created by my SQR program from the
same program.
        My code is :
let $command = 'uuencode letter.htm letter.htm > letter.uue'
call system using $command #encode_status
let $command = 'mail lkarimundackal@jhancock.com < letter.uue'
call system using $command #mail_status

My intention is to send the report as an attachment. I tried the uuencode
and the mail command
from the unix prompt and it worked great, but when I do the same commands
from SQR, the
encoded file goes as text, so the mail has a lot of junk as the text. All
the files, including the uuencoded
file is created properly from SQR and both commands have a success return
code.

Any help will be appreciated.
Thanks in advance,
Liz J Karimundackal
(617) 572-8288
e-mail : lkarimundackal@jhancock.com

pic16404.pcx