Capturing e-mail address of person who sent file

  • Thread starter Thread starter DoctorV
  • Start date Start date
D

DoctorV

I have an Excel Workbook that gets sent to different approvers. I was
wondering if when someone sends the e-mail, (Ie File Send mail
recipient As Attachment) while the file is being loaded as a temp file
can you capture the senders e-mail address in the file. I have a
worksheet named CaptureProfile and in cell A1 I would like to poplulate
it with the senders e-mail address for future reference.

How can I do this? We use Outlook 2002. We could do the send off of a
button. Thanks
 
Back
Top