Record senders email address in cell A1. Possible?

[Mister H]

Hi:

I have been searching for a while but I have yet to find a solution. I created a file that when a user clicks a button it creates an email with the workbook attached. Now I am HOPING to expand on that.

When the person receiving the email opens the attached Excel file can VBA record the Outlook SENDERS email address in Excel?

So, Mary sends the file to Bill. Bill opens the attchment and Marys email address automatically gets recorded in cell A1?

It would also be acceptable for Marys email address to be recorded in A1 before it is sent to Bill.

Can Excel VBA do this?

THANKS,
Mark