I am trying to write a program for my office where the users full name is taken from the Global Address List (GAL) of outlook, and entered into a specific cell (Currently B3).
I have tried calling the fullname object for the outlook.contactitem property, but with no luck.
The users name is to correlate to their user ID number (which they use to log onto the system). I can make this appear in a cell already, but I need the program to find this number in the GAL, and display the relative full name of the user.
Also, I need it to show, for example, "Simon Caddy" rather than "Caddy, Simon".
Any help would be greatly appreciated.