Extracting Data from E-mails to Excel

[Mightyginger]

What I'm trying to do is every day I get sent an e-mail from the same person and these e-mails have prices for different types of things. An example of the format would be
Square Rectangle Circle
Red | 10 | 11 | 12
Blue | 13 | 13 | 14
Green | 15 | 16 | 17

So what I need to do really is for each day I have this e-mail add this data to a row in excel. So for example I could have a column Square (red), Square (blue), Square (green), Rectangle (red), Rectangle (blue)...

So I suppose I'm asking several things at once
1. How can I choose just to get information from e-mails where by the e-mail address matches an e-mail address I give it
2. How can I get that e-mail message into VBA to manipulate it
3. Whats the easiest way of parsing this information (although I think I can probably handle this bit).

I've tried searching in tek tips but I can't quite find any questions people have asked that covers exactly steps 1 & 2.

Thanks for your help!


Neil.

 

[CautionMP]

Mightyginger,
You may find the bottom third of this thread helpful: thread707-1231337

CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)