+ Reply to Thread
Results 1 to 4 of 4

Create a list of Email addresses from selecting contacts in Outlook's global contact list

  1. #1
    Registered User
    Join Date
    11-14-2014
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    3

    Create a list of Email addresses from selecting contacts in Outlook's global contact list

    Hi Guys,
    I'm wanting to create some VBA code that would create a list of Email addresses and store them in a worksheet for later use, from selected contacts in Outlook's global contact list.
    So how I want this to happen would be to:
    1. Open excel with said spreadsheet;
    2. click a button to open outlooks Global contact list;
    3. Select the required contacts from the list;
    4. Excel would via VBA take the selected contacts Name, Email address and location from the Global contact list; and
    5. Store them in a spread sheet for later use via VBA again.


    Is this possible? I've been searching the interwebs and have so far turned up nada. I can find code to get ALL the addresses in a contacts list, but not only the selected ones.
    Cheers guys and thanks for the help in advance,
    Nimrod

  2. #2
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Create a list of Email addresses from selecting contacts in Outlook's global contact l

    Hi Nimrod,

    Can you just not import all contacts into a worksheet tab and than delete the ones you are not interested in, or mark the ones you are interested in. Whether you make the selection in Outlook or in Excel does not make must of a difference in terms of effort. Am I missing something?
    If you like my contribution click the star icon!

  3. #3
    Registered User
    Join Date
    11-14-2014
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    3

    Re: Create a list of Email addresses from selecting contacts in Outlook's global contact l

    I could import all the contracts from the global list but the number of contracts on that list is enormous (many thousands). I only really want to be able to select the contracts that I want for my use as you would when selecting recipients for an email.
    Could excel collect the data from the To: box in an email after our before it has been sent?
    That would achieve my purpose.... Just not sure where to start.
    Thanks for your reply Ollie!

  4. #4
    Registered User
    Join Date
    11-14-2014
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    3

    Re: Create a list of Email addresses from selecting contacts in Outlook's global contact l

    Hi again,
    I found this code and it does almost exactly what I need.

    I have modified the code to put the gathered information and place it into cells on the active worksheet. Does anyone have a way to do this that is more elegant? Also, can anyone tell me how to remove the comma (,) from the end of each contact's details within VBA?


    Please Login or Register  to view this content.
    Thanks again
    Last edited by nimrod77; 11-29-2014 at 09:12 AM.

+ 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: 4
    Last Post: 03-22-2013, 02:03 AM
  2. Contact List to Word to Outlook
    By aus10fek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2011, 05:09 PM
  3. Extracting Contacts list in Global Address List
    By suryaprasad in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-10-2011, 06:47 PM
  4. Replies: 1
    Last Post: 12-31-2007, 09:28 AM
  5. [SOLVED] Using CONCATENATE function to create email addresses from a list
    By Almamba in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-23-2005, 06:06 PM

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