Re: Writing SQR Interface - needs to email a file

["Fetzik, John" <JFetzik@SANDC.COM>]

There are a number of simple command line programs that can send mail via
SMTP that you can call from SQR. Here are some links to a few that I have
used.

Command Mail - http://www.xwebware.com/products/commail/
GBMail - http://gboban.hypermart.net
BLAT - http://www.interlog.com/~tcharron/blat.html

I currently wrap the SQR and email calls into a Windows batch file like
below. You could just make the call from the SQR using call system using.

  S:\SQRW\SQRW.EXE D:\DAILYSQR\SCINTLOG.SQR INTLOG/ABCXYZ@DBHR -XCB
@SCINTLOG.DAT
  commail -to=jfetzik@sandc.com -config=D:\DAILYSQR\SCINTLOG.INI

SCINTLOG.DAT and SCINTLOG.INI are used to keep the command lines short
enough to work in Windows.

SCINTLOG.DAT has the usual -o -f -E -m SQR command line options.

SCINTLOG.INI tells Command Mail things like the mail server name, subject,
the message text(which is D:\DAILYSQR\SCINTLOG.LIS), etc.

If you have any more questions just post them to the list.

--
John S. Fetzik
S&C Electric Company
773-338-1000 x2763
jfetzik@sandc.com


> -----Original Message-----
> From: Joe [mailto:jej1216@YAHOO.COM]
> Sent: Wednesday, May 23, 2001 3:24 PM
> To: SQR-USERS@list.iex.net
> Subject: Writing SQR Interface - needs to email a file
>
>
> Greetings,
>
> Does anyone have an example/advice/reference of an SQR
> Interface that e-mails a file or uploads a file to a website
> automatically upon crfeation of the file?
>
> We need to extract data and either e-mail or upload a *.prn
> file weekly to a 401K provider.
>
> Any help would be appreciated.
>
> Thanks,
>
> Joe Johnson
>