I get a daily operating report email about my company's 400 servers. 10 of
these servers are of interest to me, and, of course, they're spread all
thoughout the email. The report is an embedded Excel spreadsheet (it's
actually the text of the email, not an attachment).

I want to write a script that can be run from an Outlook Rule to scan the
email when it arrives and give me just the rows for my servers. I'm familiar
with VBA, but not for doing something like this in Outlook. Anyone have any
ideas on how to accomplish this?



--
Cheers,

Buddy

You can search text within the Body property with the InStr function. The
carriage return at a line's end is vbCRLF in plain text. Once you found the
start and end of what you're looking for you can extract it with the Mid
function.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Keep your Outlook categories organized!
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)


Am Mon, 5 Feb 2007 09:12:00 -0800 schrieb Buddy:

I get a daily operating report email about my company's 400 servers. 10
of
these servers are of interest to me, and, of course, they're spread all
thoughout the email. The report is an embedded Excel spreadsheet (it's
actually the text of the email, not an attachment).

I want to write a script that can be run from an Outlook Rule to scan the
email when it arrives and give me just the rows for my servers. I'm
familiar
with VBA, but not for doing something like this in Outlook. Anyone have
any
ideas on how to accomplish this?