![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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 |
Ads |
#2
|
|||
|
|||
![]() 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Extract Email info | Dave | Outlook - Using Contacts | 0 | October 27th 06 04:34 AM |
Missing content when synchronizing between Outlook and WM5 PDA & p | larsfe | Outlook - Calandaring | 0 | September 27th 06 12:04 PM |
extract all the text from a email in outlook | .·:m·a·r·l·a:·. | Outlook - General Queries | 4 | August 19th 06 08:50 PM |
How do I protect my calendar & mail from others deleting content | miciabella | Outlook - Calandaring | 1 | June 27th 06 11:39 PM |
auto scan email content for dates/times, generate calendar entry | cagphd | Outlook - Calandaring | 1 | February 25th 06 05:17 AM |