Hi Graham - again, thank you so much for taking the time to help me with this. I guess i am not as good at this as i thought....

Here are my questions:Here's an example email of exactly what data i am trying to pull:

"
The following deal has been approved and associated to one of your accounts:
Deal ID: XXXXXXXX
"

What i need the macro to do, is search the folder for any emails that have "The following deal has been approved and associated to one of your accounts:" and then export the number (XXXXXXXX) that comes after "Deal ID:" The XXXXXXXX is going to be different for each email. That variable is not constant but is always 8-digits.Would i run this macro from Outlook, or run it from Excel?

Also, there is a light blue border around the text, so I am not sure if that effects the macro's ability to pull the data. The border is not an embedded image. Below is a screenshot from the border that is around the text. It's the blue line.
Code.JPG
Again, i really appreciate you taking the time to help me on this.