Hi guys

My company has a global address book on it's Outlook server and every
employee has their logon User ID entered in the 'Alias' field.

Is there a way I can enter code so that upon clicking a button, the VBA
looks up the value in a textbox (in this case a user ID), matches it to the
email address held against that User ID alias on the GAB and returns the
email address into a label?

Or to put it simpler:

1 - User enters their ID into txtbox1
2 - User clicks button to validate
3 - Code searches GAB for 'blogg1j' to match to
4 - Returns ' into label1

Thanks!