There's plenty of code examples to find on how to enum
the outlook mails in a folder.
Have you looked for them?
Important: Are you using Redemption?
http://www.dimastr.com/redemption/
If it's on your own machine only I would install it.
Then ONCE we have a FOLDER object
we can loop thru the ITEMS
verify it's class is olMAILITEM
read the BODY
before i start coding this ..
Any way to identify those numbers?
Or is it basically reading the textstream until you find a four digit
number?
Are the emails PlainText or RTF or HTML?
--
keepITcool
|
www.XLsupport.com | keepITcool chello nl | amsterdam
ForSale wrote :
I need a macro that will look in a certain folder in Outlook and get a
four-digit number from each e-mail. Basically, instead of the whole
e-mail including signatures and text, i just need the numbers. if it
is not possible to only get those from Outlook, maybe it would be
possible to pull all of the items in the folder to Excel, then pick
out the numbers from there?
Thanks in advance
---
Message posted from http://www.ExcelForum.com/