Retrieve name from Outlook based on employee number entry

[rvdb20]

Hi,

I am looking for the following: I have a datasheet where I want to know who entered the sheet. I want the user to enter his Corporate number and I want VBA to check this number in the Global Adress List to give back the name of that person.

So let's say I enter my Corporate number in Cell A1.. How can I get my name in Cell A2?

This would really help me a lot! So thanks for helping!