A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Scan & Extract Email Content



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 5th 07, 06:12 PM posted to microsoft.public.outlook.program_vba
Buddy
external usenet poster
 
Posts: 7
Default Scan & Extract Email Content

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  
Old February 6th 07, 06:57 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Scan & Extract Email Content


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 07:11 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.