Re: Sending E-mail from SQR...

[Vicki Lo <VLo@DATASTUDYINC.COM>]

You can use SQR to send e-mail, but you have to know the mail sever address
and send the mails there. Also, have to declare the output(text of the mail)
to be
80000 character per line so the text wouldn't be wrapping.
eg.
begin-setup
declare-layout default
  paper-size=(80000,10)
  right-margin=0
  left-margin=0
  bottom-margin=0
  formfeed=no
  orientation=landscape
 end-declare
end-setup

String the text into a variable field and print the variable.
Concat the output file with mail sever address.
eg:
 let $host_string = '$HOME/famil2.pl ' || $hr_email || '  ' ||
$email_subject || '< '  || $out_file
 let $directory = getenv('HOME')
     let $out_file = $directory || '/out_mail/new_hire.lis'
     new-report $out_file
 call system using $host_string #mail_status

Have fun!

Vicki




> -----Original Message-----
> From: Kulshrestha, Alok [SMTP:ALOKKULSHRESTHA@IMF.ORG]
> Sent: Tuesday, October 06, 1998 10:40 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Sending E-mail from SQR...
>
> SQR Version     : 3.0.18.0
> Database        : Oracle 7.3
> Platform        : Windows95
>
> I have a requirement where I need to send e-mail notification, once my
> program has finished. I use Outlook as my E-mail application. Is there
> anyway to send e-mail from SQR when running on windows 95.
>
> Any help will be appreciated.
>
> Thanks.
> -alok Kulshrestha