I want to insert a text file into an email as opposed making it an attachment

I am the network security admin for my company. I am automating the
processing of my firewall syslog files to have it email the offenders abuse
and security email addresses.

My issue is that many abuse and security email addresses delete incoming
attachments so I need to insert the syslog data as opposed to mailing it as
an attachment.

For the same reasons that the above addresses delete attachmants they also
do not accept html or rtf emails so I can not use CreateMHTMLBody.

Short of generating vbscipt code with hundreds of lines of
"data" & vbCRLF & _

Is there some way to do this?

Or can someone recommend a command line emailer that will let me do this?

BTW: I have automated prossing the syslog files themselves with awk, grep
and uniq by using the bash shell cygwin under windows. If you have got to
process text in large quantities I can not say enough about awk.

Robert
Mon Mar 01 13:26:45 CST 2004

one thing to consider, put the log into a database and have the script send
an e-mail saying that the database has been updated. That way, you don't
have to e-mail the data to all your users. The other idea is to open the
file as a text file and copy the text into your e-mail. But you will loose
the formatting that way. But I am sure others will have a better way as I
am fairly new to this. The true masters will have some good ideas.

--
Robert Cohen
A legend in his own mind
--

"Sheepdog" <ng.20.shep@spamgourmet.com> wrote in message
news:#AK#TL6$DHA.2180@TK2MSFTNGP09.phx.gbl...
> I am the network security admin for my company. I am automating the
> processing of my firewall syslog files to have it email the offenders
abuse
> and security email addresses.
>
> My issue is that many abuse and security email addresses delete incoming
> attachments so I need to insert the syslog data as opposed to mailing it
as
> an attachment.
>
> For the same reasons that the above addresses delete attachmants they also
> do not accept html or rtf emails so I can not use CreateMHTMLBody.
>
> Short of generating vbscipt code with hundreds of lines of
> "data" & vbCRLF & _
>
> Is there some way to do this?
>
> Or can someone recommend a command line emailer that will let me do this?
>
> BTW: I have automated prossing the syslog files themselves with awk, grep
> and uniq by using the bash shell cygwin under windows. If you have got to
> process text in large quantities I can not say enough about awk.
>
>

Torgeir
Mon Mar 01 14:04:21 CST 2004

Sheepdog wrote:

> Or can someone recommend a command line emailer that will let me do this?

Hi

I don't know, but maybe Blat can help you with this...

Blat homepage
http://www.interlog.com/~tcharron/blat.html

A Google newsgroup search:
http://groups.google.com/groups?as_q=blat&as_ugroup=*.scripting


--
torgeir
Microsoft MVP Scripting and WMI, Porsgrunn Norway
Administration scripting examples and an ONLINE version of the 1328 page
Scripting Guide: http://www.microsoft.com/technet/scriptcenter

Roland
Tue Mar 02 01:42:57 CST 2004

"Sheepdog" <ng.20.shep@spamgourmet.com> wrote in message
news:%23AK%23TL6$DHA.2180@TK2MSFTNGP09.phx.gbl...
: I am the network security admin for my company. I am automating the
: processing of my firewall syslog files to have it email the offenders
abuse
: and security email addresses.
:
: My issue is that many abuse and security email addresses delete incoming
: attachments so I need to insert the syslog data as opposed to mailing it
as
: an attachment.
:
: For the same reasons that the above addresses delete attachmants they also
: do not accept html or rtf emails so I can not use CreateMHTMLBody.
:
: Short of generating vbscipt code with hundreds of lines of
: "data" & vbCRLF & _
:
: Is there some way to do this?
:
: Or can someone recommend a command line emailer that will let me do this?
:
: BTW: I have automated prossing the syslog files themselves with awk, grep
: and uniq by using the bash shell cygwin under windows. If you have got to
: process text in large quantities I can not say enough about awk.

I agree that putting the data in a SQL database would be better and just
send a quick email that reports are ready. If you would rather send the
data in an email, then knowing your setup would help.

Server OS?
Email Server?
How many servers are involved?
Will one server consolidate the report of all or will each send their own
email?
...etc...

It helps to know all the players and the desired method with the desired
result. Someone should be able to get you going from there.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

Sheepdog
Thu Mar 04 09:22:57 CST 2004

blat worked great for what I wanted to do.

The emails are being sent to other ISPs and generating the address for a
given IP address is not a trivial task. For most I can use output from
"ping -a" but others I have to resort to using plowing thru whois output.

"Roland Hall" <nobody@nowhere> wrote in message
news:%237RoHlCAEHA.1456@TK2MSFTNGP09.phx.gbl...
> "Sheepdog" <ng.20.shep@spamgourmet.com> wrote in message
> news:%23AK%23TL6$DHA.2180@TK2MSFTNGP09.phx.gbl...
> : I am the network security admin for my company. I am automating the
> : processing of my firewall syslog files to have it email the offenders
> abuse
> : and security email addresses.
> :
> : My issue is that many abuse and security email addresses delete incoming
> : attachments so I need to insert the syslog data as opposed to mailing it
> as
> : an attachment.
> :
> : For the same reasons that the above addresses delete attachmants they
also
> : do not accept html or rtf emails so I can not use CreateMHTMLBody.
> :
> : Short of generating vbscipt code with hundreds of lines of
> : "data" & vbCRLF & _
> :
> : Is there some way to do this?
> :
> : Or can someone recommend a command line emailer that will let me do
this?
> :
> : BTW: I have automated prossing the syslog files themselves with awk,
grep
> : and uniq by using the bash shell cygwin under windows. If you have got
to
> : process text in large quantities I can not say enough about awk.
>
> I agree that putting the data in a SQL database would be better and just
> send a quick email that reports are ready. If you would rather send the
> data in an email, then knowing your setup would help.
>
> Server OS?
> Email Server?
> How many servers are involved?
> Will one server consolidate the report of all or will each send their own
> email?
> ...etc...
>
> It helps to know all the players and the desired method with the desired
> result. Someone should be able to get you going from there.
>
> --
> Roland Hall
> /* This information is distributed in the hope that it will be useful, but
> without any warranty; without even the implied warranty of merchantability
> or fitness for a particular purpose. */
> Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
> WSH 5.6 Documentation -
http://msdn.microsoft.com/downloads/list/webdev.asp
> MSDN Library - http://msdn.microsoft.com/library/default.asp
>
>