NT User Name to get Outlook information

  • I am trying to use the NT id of the person logged into the computer to sign an email. I am trying to translate the ID into the First Name, Last Name & Telephone Number of the person (all are stored on the company address book). I use the below code to get the NT User ID:



    How do I take the username and look up the contact infor from the outlook address book?

    :thanx: Tony

  • Re: NT User Name to get Outlook information


    a quick aside...


    there are a collection of "environ" variables available in XL - one such variable pulls the active NT


    eg


    Code
    Dim user as string
    user = environ("username")


    saves a lot of code


    as for pulling the contact info - you would need to loop the global address book entries .... I would think there are examples listed in this section of the forum... if not post back and we can put up some code.

  • Re: NT User Name to get Outlook information


    I was able to find some code to download the entire address book but nothing to find info on just one person. Specifically, I am looking for the first and last name and the telephone number

    :thanx: Tony

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!