+ Reply to Thread
Results 1 to 4 of 4

Excel VBA LDAP Emails Active Directory - Trouble with Range Code

  1. #1
    Registered User
    Join Date
    10-23-2014
    Location
    USA
    MS-Off Ver
    Newest
    Posts
    7

    Question Excel VBA LDAP Emails Active Directory - Trouble with Range Code

    Windows: Microsoft? Excel? for Microsoft 365 MSO (Version 2205 Build 16.0.15225.20348) 64-bit

    I have a list of 20,000 emails. Typically, when you enter someone's email in Outlook, it will return the member's title. My outlook is only connected to my company email service. Is there a way to have excel search a list of emails and return the Outlook titles in a list of empty cells?

    Ex.
    Email
    chuck.norris at us.navy.mil

    Desired Outlook Title Return
    NORRIS, CHUCK P KARATE USNC 318 COBRA/KAI
    Last edited by Article92; 09-21-2022 at 07:26 PM. Reason: Change Title

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,777

    Re: Have Excel search Company's Outlook for email and return the Title of the member

    Administrative Note:

    Members will tailor the solutions they offer to the version (NOT 'newest', please) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    10-23-2014
    Location
    USA
    MS-Off Ver
    Newest
    Posts
    7

    Re: Have Excel search Company's Outlook for email and return the Title of the member

    It is Windows: Microsoft? Excel? for Microsoft 365 MSO (Version 2205 Build 16.0.15225.20348) 64-bit

  4. #4
    Registered User
    Join Date
    10-23-2014
    Location
    USA
    MS-Off Ver
    Newest
    Posts
    7

    Re: Have Excel search Company's Outlook for email and return the Title of the member

    I have attached VBA code, but can't seem to get it to work with Ranges
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 12-10-2020, 06:28 PM
  2. [SOLVED] Search a sheet for a song title and return Album title
    By A440 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-28-2016, 10:19 AM
  3. Replies: 0
    Last Post: 04-14-2015, 05:44 PM
  4. Replies: 1
    Last Post: 04-08-2015, 05:46 PM
  5. [SOLVED] EXCEL VBA - Problem to search an email in Outlook folder
    By gkumthekar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2013, 05:08 AM
  6. Replies: 0
    Last Post: 06-26-2013, 01:18 PM
  7. search outlook contacts in excel and return email address to variable
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2008, 06:08 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1