VBA get current system login details with Email id

[mnsathishk]

Get current system login details with Email id and update in Excel sheet by Vba

 

[Kamolga]

if outlook 16.0 object library is ticked in reference/tools

the 3rd gives me the email adress

Debug.Print Application.UserName
Debug.Print Environ("username")
Debug.Print Outlook.Application.Session.CurrentUser.Address