T
Tom Jones
Hi there,
I have a few batch files that run on my servers every night which then
email me if they finish successfully. At the moment I have a rules wizard
that moves those mails into appropriate folders but I would now like to be
able to analyze those emails somehow and place a "YES" or "NO" into excel
cells dependant on if an email exists or not. Here is an example:
I run nightly defrag batches on my servers every night. I then get an email
with a Subject line of "Defrag report: servername.domainname.local" and a
message body of "Computer: servername.domainname.local successfully
completed defrag at 03:22:16.20 on 11/06/2004"
I need a batch/vbs that will look out for the computer name in either the
email message or the subject and pass the result into a corresponding cell
in an excel spreadsheet.
Any help with this, or even if you can point me at an article that might be
relevant, that would be greatly appreciated.
Thanks in advance
Tom.
I have a few batch files that run on my servers every night which then
email me if they finish successfully. At the moment I have a rules wizard
that moves those mails into appropriate folders but I would now like to be
able to analyze those emails somehow and place a "YES" or "NO" into excel
cells dependant on if an email exists or not. Here is an example:
I run nightly defrag batches on my servers every night. I then get an email
with a Subject line of "Defrag report: servername.domainname.local" and a
message body of "Computer: servername.domainname.local successfully
completed defrag at 03:22:16.20 on 11/06/2004"
I need a batch/vbs that will look out for the computer name in either the
email message or the subject and pass the result into a corresponding cell
in an excel spreadsheet.
Any help with this, or even if you can point me at an article that might be
relevant, that would be greatly appreciated.
Thanks in advance
Tom.