Re: Sending E-mail from SQR...

["Matthew F. Reagan" <mreagan@FAST.NET>]

Alok,

I have been doing some research on that very issue (sending e-mail from
SQR) and have found two products that are available to let you do this.
They are:

BatMail by On3

You can find information on it at http://www.on3.com/tools/nt/mailexe/

You can buy it as an executable command line program or as a dll.  I have
been testing it as an executable.  It takes a configuration file and a
message file as the required parameters and supports a single attachment
that will be MIME encoded automatically.

The configuration file contains items like what should be on the FROM line,
the SUBJECT line, the REPLYTO line (if different from the FROM line), the
name or IP address of the SMTP relay, an optional file that specifies the
BCC list, etc.

It costs $99 per "server".  It says NT, but I've been using it successfully
on Win 95.

My SQR program builds the appropriate files and FTPs them to a drop box.
Its part of a central report generation and distribution system I'm
building to support report requests from Win '95 GUI tools that run on a
central server, and are distributed through an FTP drop box monitored by a
PERL script that does the actual invocation.  Anyone attempting this
another way?

The second option is SPIMail by AJSoftware

You can find information onn it at http://www.ajsoftware.com/SPIMail.htm.

It uses a similar command line interface, but permits command line switches
to specify the parameters in addition to supporting a configuration file.

It costs $19 a user, $100 for an unrestricted license, or $300 for the
source code.

I have not tested the second option (yet).

I also have an intrepid PERL programmer who is attempting to implement a
direct SMTP link without relying on third party products.  If he does that
successfully, I'd be more than happy to post the results.

Let me know if you find any other options.

Matt...

At 12:02 AM 10/7/98 +1800, you wrote:
>Date:    Tue, 6 Oct 1998 10:39:44 -0400
>From:    "Kulshrestha, Alok" <ALOKKULSHRESTHA@IMF.ORG>
>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
>



Matthew F. Reagan * Strategic Technical Consulting, Inc.
mreagan@fast.net  * Certified Oracle DBA/Certified SQR Instructor