How to gather data from Outlook Emails to put into Excel (using Excel VBA)

Hi all,

I'm wondering if anyone ever tapped into Outlook via Excel VBA. if so may I ask how to:

*For each email in any Outlook folder from the last 24 hours, which has the Subject of: "ID ### Status":
(### will be a 3 or 4 digit ID-Number, occasionally starting with the letter v)

1) In the email body get the text that follows:
"Percentage Complete: " <--- e.g. the text might be "100%"

2) Store that value in col "A", in the row where col B = the same ID number as in the email subject
(If that ID number does not exist in column B, then just move to the next email)


--- Hopefully this is easily doable. (btw: There will be less emails in 24h than Excel rows, so it might be faster to traverse emails first -- also I have to run it from VBA code in an Excel spreadsheet)

Much thanks in advance for the help,
-jmc

That's a big ask to code from scratch - have a look at something like this to get you stated