I create reports and need to send it to users.
Sometimes it is 50 and sometimes its 300.
I am using Ms outlook 2007, its a Ms Exchange type.
If I want to send an email to ABC, I type ABC in outlook and press Ctrl k and outlook automatically finds his names and email address.
I cannot see there email address easily, I have to double click and check their info.
Even copy paste doesn't work.
Some times if there are 2 or more people with similar name, then I have to identify them by checking properties.

I want a VBA code to query Full Name or Emp id for several employess and get their email from Active Directory, it would be a super difficult thing to do.
Also if possible, can I get their Username, OU, Login/Logoff time, Computer Name, Reporting Manager, Department, Thanks in Advance