ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Global Address Book Question (https://www.excelbanter.com/excel-programming/411616-global-address-book-question.html)

Dan V[_2_]

Global Address Book Question
 
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!


All times are GMT +1. The time now is 08:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com