Attempting to attach an Excel document to an email created using BLAT

[McKaba, Melanie]

I am hoping for some help with using BLAT.  Blat is a Win32 command line utility that sends eMail using SMTP or post to usenet using NNTP.

Environment is jBase ver. 3.4.9 and BLAT ver.  2.6.2 w/GSS encryption

I cannot seem to get a Excel document to attach to an email that I send out to myself using BLAT from within a subroutine.  The statement that gets built within the subroutine is as follows:

BLAT d:\jEmail\mmckaba.txt -to mmc...@superiorink.net -subject "Customers Addresses Rpt" -mailfrom mmc...@superiorink.net -attach "C:\CMF.FOR.3YRS.xls"

I get an email every time but there is no attachment.

Any ideas what I can do to make this work?

Thanks!     Melanie

[Jim Idle]

McKaba, Melanie wrote:

I am hoping for some help with using BLAT.  Blat is a Win32 command line utility that sends eMail using SMTP or post to usenet using NNTP.

Environment is jBase ver. 3.4.9 and BLAT ver.  2.6.2 w/GSS encryption

I cannot seem to get a Excel document to attach to an email that I send out to myself using BLAT from within a subroutine.  The statement that gets built within the subroutine is as follows:

BLAT d:\jEmail\mmckaba.txt -to mmc...@superiorink.net -subject "Customers Addresses Rpt" -mailfrom mmc...@superiorink.net -attach "C:\CMF.FOR.3YRS.xls"

I assume that this is actuality the output of a CRT/PRINT statement? Perhaps you need to tell EXECUTE using a shell? EXECUTE CHAR(255):'k':"BLAT ..."

I get an email every time but there is no attachment.

Any ideas what I can do to make this work?

CRT the statement before executing it and make sure that if you past this into a normal shell, that it is working correctly. Use the CAPTURING and SETTING clauses on EXECUTE to find out what the command is returning to you.

Jim

[time]

Have you tried setting the -log switch?  This may help.

Tim.

[McKaba, Melanie]

Thanks for your help, it turns out the Excel document I was trying to attach was not on the same server as BLAT.  Once I changed where the Excel document resided, it worked.