Re: Emailing a Report from within an SQR on Unix with MS Outlook Emai l

[Shankar Veerashetty <sveerashetty@ASSISTED.COM>]

E-Mail the report from SQR. The server address has to be known and have to
declare the output to be 80000 characters per line so that the text wouldn't
be wrapping.
Eg.
Begin-setup
  Declare-layout default
  Paper-size = (80000,10)
  Right-margin=0
...
end-setup
let $host_string='$HOME/famil2.pl'||$hr_email||' ' ||
$email_subject || '<' || $out_file
let $directory = getenv('HOME')
let $outfile = $directory || '/outmail/new_hire.lis'
 new-report $outfile
call system using $host_string #mail_status

Thanks,
Shankar Veerashetty
Senior Consultant
Software Associates Inc.
(734)678-6696

        -----Original Message-----
        From:   Dan Harmuth [SMTP:DHarmu1@TANDY.COM]
        Sent:   Monday, April 05, 1999 5:07 PM
        To:     Multiple recipients of list SQR-USERS
        Subject:        Emailing a Report from within an SQR on Unix with MS
Outlook Emai l

        SQR/4.3.2/PC/Windows NT 4.0/Oracle 7.3.4/Sep 14 1998 ((run from
client;
        running HP Unix))

        Has anyone ever created an SQR that can email a report generated
from
        within.

        My environment is HP Unix with MS Outlook Email.

        Dan Harmuth
        Project Lead - PeopleSoft HRMS
        817-415-2224
        dharmu1@tandy.com