Stift

Start here

http://www.dicks-clicks.com/excel/olRetrieving.htm

You need to parse out the Body property, looking for those keywords. See
what you can do with the above link, then if you need help with the specific
parsing of the Body, post back.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Stift " wrote in message
...
Hi ,I'm new to this forum,and am not very good in VBA.I'll explain my
problem:

Every Friday I'll get a mail from someone with a few numbers.
He uses a standard lay-out for it and looks like :

Hi here the numbers of week 17
seacontainers : 5
storagecontainers : 15

Now I every week copy these numbers and put them in a excel-
file. :(
Is there a possibillity to automate this???
What do I have to do?


Thanks in advance!


Stift


---
Message posted from http://www.ExcelForum.com/