I have a spreadsheet which I'd like to auto run an macro upon opening, capture the user's email address based upon which will then do a set list of custom actions dependant upon the user.

The "Everything else" I've got written but am having trouble being able to find the user's email address from outlook ...

I could use
VB Code:
  1. application.username
but the 'username' is listed as an ID such as 'abc123' rather than the users name so I'd then need to hard code a translation that shows that 'abc123' = 'Clifford Wright' etc ..

anyone any ideas?

I did try;

VB Code:
  1. Dim oApp As Outlook.Application

  2. Dim hello

  3.  
  4. hello = oApp.Application.UserName

but I think I'm mixing things up here plus I think the outlook username will also be 'abc123'

Any ideas how I can find the user's default email address?

Cheers