+ Reply to Thread
Results 1 to 5 of 5

Check names against email global list in outlook

  1. #1
    Forum Contributor
    Join Date
    02-12-2018
    Location
    Clearwater, FL
    MS-Off Ver
    MS 365
    Posts
    214

    Check names against email global list in outlook

    I have a sheet with the person's 1st name in Column A & Last name in Column B - I would like a button with a code that will look at their names in Outlook global list and pull their email address and put it in column C on the same page. When I click on the button, I would like for it to update any new ones that may be there or overwrite the ones that are gone. Is this possible - any help would be greatly appreciated!

  2. #2
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    274

    Re: Check names against email global list in outlook

    You want some pretty advanced features there, but honestly a better approach would be to have Outlook open your spreadsheet and fill it out since for security reasons Excel doesn't have access to the GAL.
    If it'd make you feel better using my answer because of my street cred, then you can go ahead and click Add Reputation below to improve it.

  3. #3
    Forum Contributor
    Join Date
    02-12-2018
    Location
    Clearwater, FL
    MS-Off Ver
    MS 365
    Posts
    214
    Quote Originally Posted by Gregor y View Post
    You want some pretty advanced features there, but honestly a better approach would be to have Outlook open your spreadsheet and fill it out since for security reasons Excel doesn't have access to the GAL.
    And what would a code like that look like?

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  5. #5
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    274

    Re: Check names against email global list in outlook

    nice list, I found this one helpful too

    How to: Get the SMTP Address of the Sender of a Mail Item

    In Ms-Outlook, add the Excel Ref: VBE>Tools>References>Microsoft Excel xx.x Object Library>OK
    Please Login or Register  to view this content.
    Note: this code probably has a few bugs to work out as I didn't run a test file through it, but I stuck to the OP's original setup: ColA:=FirstName, ColB:=LastName, ColC:=EmailAddr, ColD:='Not Found'

+ 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. VBA Outlook Email "Check Names"
    By musicman1985 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-11-2019, 03:53 PM
  2. Global address list in Outlook
    By jackcell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-28-2017, 05:08 AM
  3. Replies: 4
    Last Post: 05-04-2017, 03:57 AM
  4. Replies: 3
    Last Post: 12-17-2015, 04:23 PM
  5. Export list of names to outlook and add their email to contact group
    By vamosj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2015, 02:01 PM
  6. Replies: 3
    Last Post: 11-29-2014, 07:30 AM
  7. Check Names in Outlook, email created with Excel VBA
    By BlueValentine in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-04-2013, 12:27 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