Extract Senders Email Address

I have a workbook that many users on the network access to report workplace injuries. I have it set up so that a quick summary is sent out to multiple email addresses shortly after the event, but the user will have to complete another tab in the same workbook to complete an accident investigation. This report is supposed to be emailed out within 24 hours. This does not always happen. All the emails are created and sent out with buttons that fires 2 separate email macros, 1 for the summary immediate after event and 1 when Investigation is complete, and everything works fine. I need a way to send a reminder to user that the Investigation is due. I have done some searching and have been unable to come up with a solution. I would like to extract the users emails address (on Microsoft Exchange) and have a delayed send email in their outbox that will send themselves an email that will remind them to complete report. I can create the code that will send the delayed email, but is there a way to get the users email address from outlook? I needs to create an email that will delay send to themselves.


Thanks
Chris

What information do you have about the users that you can use to search for their account on AD?

Each user will be logged in to the network using their own username and password, so it will always be the logged in user's default outlook account.

This little function will return the logged in user's email address:

Please Login or Register  to view this content.

I have just done a quick test, and this may be exactly what I am looking for. I will test this with a few of the users, before I mark it solved.

Thank you very much
Chris