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:
- Open excel with said spreadsheet;
- click a button to open outlooks Global contact list;
- Select the required contacts from the list;
- Excel would via VBA take the selected contacts Name, Email address and location from the Global contact list; and
- 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
Bookmarks