I am looking for a code for Excel to pull a name from the body of the email address. Below is a better explanation.

I receive an email with a certain subject and it opens up an Excel file I have saved to my computer.

This email has name: "an email address here" in the body of the email.


What I need is for that Excel file that opens up, to pull that email address from the body of the email into cell "D1" in Sheet1. I can handle the rest after that.

Again, the email will have a certain distinct subject like: "Test", and will have name: "email address" in the body.

Any help would be appreciated. Thanks.