Capturing e-mail address of person who sent file

[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

 

[Dave Peterson]

Ron de Bruin has lots of samples of macros that will email workbooks at:
http://www.rondebruin.nl

And Dick Kusleika has some (especially Outlook) at:
http://dicks-clicks.com/excel/olAutomating.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm