+ Reply to Thread
Results 1 to 4 of 4

Excel Macro to pull Outlook email addresses from Global addres list into the sheet

  1. #1
    Registered User
    Join Date
    02-11-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2007 or Excel 2010.
    Posts
    65

    Excel Macro to pull Outlook email addresses from Global addres list into the sheet

    Hi Team,

    I am in need of a macro which should take the alias which is after the backward slash that is a123456 and it should look it up in Outlook Global address list and paste their name and email address in their respective cell.

    Below is an example just for one instance:

    Creator
    abcd\a123456

    should show up like

    Creator
    Tom Johnson<Tjohnson@abc.com> and this has to be done for the rest of the rows with different alias under creator as shown in attachment

    Kind Regards,

    4gurus
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2019
    Posts
    6,593

    Re: Excel Macro to pull Outlook email addresses from Global addres list into the sheet

    Maybe this link helps?
    http://www.vbaexpress.com/kb/getarticle.php?kb_id=222

    I Googled you question
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    02-11-2013
    Location
    Bangalore
    MS-Off Ver
    Excel 2007 or Excel 2010.
    Posts
    65

    Re: Excel Macro to pull Outlook email addresses from Global addres list into the sheet

    Hi Keebellah,

    Thanks for the link but I forgot to mention I am a vba novice and may not now which piece of the code to use. If you can provide me a small piece of code which I can run to populate those columns that would be great.

    Thanks!
    4gurus

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2019
    Posts
    6,593

    Re: Excel Macro to pull Outlook email addresses from Global addres list into the sheet

    Hi 4gurus,
    I'm sorry I cannot help you any further. I do not have an exchange server running.
    All you have to do is explained in the link.
    Download the file mentioned unzip the file.
    Open the file and Press Alt+F8 it's explained. what happens from there on, well you will need someone with some vba knowledge to help you on.

    I've attached the file for you here (unzipped).

    Good luck.
    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. [SOLVED] Macro to open Outlook and send one email to multiple addresses from excel columns
    By telcocook in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2015, 10:11 AM
  2. Replies: 3
    Last Post: 11-29-2014, 07:30 AM
  3. vba pull data from outlook body of email through email or subject of mail into excel
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2014, 04:37 AM
  4. Sending email addresses in excel via outlook
    By dwarford101 in forum Excel General
    Replies: 1
    Last Post: 10-16-2009, 07:51 AM
  5. outlook macro to pull in a table from excel file to email.
    By chewwy in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2009, 03:10 PM
  6. How do I export email addresses from Excel to Outlook?
    By JasonLi in forum Excel General
    Replies: 2
    Last Post: 05-22-2006, 10:55 AM
  7. How do I export email addresses from excel to outlook?
    By Mark Davies in forum Excel General
    Replies: 1
    Last Post: 02-02-2005, 10:06 AM

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