Pull data from Outlook contacts

Leith Ross helped me a couple years ago with the code below, that searches for an Outlook contact with the same name as that in the active cell. If a match is found, the Outlook card pops up. What feature I would like to add now is the ability to act on a cell or userform field that contains a contact name or a company name, run a search in Contacts and then fill a userform with all the pertinent fields (e.g. address, phone numbers, email address). It would be even better if the first several matches populated the userform fields, allowing the user to choose the correct match (e.g. two John Smiths) to load into the worksheet.

Here is the contact card pop-up procedure that works perfectly:

Please Login or Register  to view this content.

I know this is a start, but I need some help here. I think if I had the Outlook Contacts field names, that would help, but I am way outside my level of expertise.

Thanks in advance for your help!

Eric

I am wondering if anyone has tried anything like this. It seems like it would be a beneficial thing for a lot of people, to pull data from Outlook - client contact info, addresses, etc. I just don't know anything for VBA outside of Excel, and the macro recorder is no help.

I cross-posted here: http://www.thecodecage.com/forumz/mi...-contacts.html

Very good material on this found here: http://www.snb-vba.eu/VBA_Outlook_external_en.html#L131