How to get Outlook address book details to MS excel?

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Reply

Join Date: Jun 2009
Posts: 1
Reputation: anishmbait is an unknown quantity at this point 
Solved Threads: 0
anishmbait anishmbait is offline Offline
Newbie Poster

How to get Outlook address book details to MS excel?

 
0
  #1
Jun 11th, 2009
Hi colleagues,

How do I get the DISPLAY NAME, PHONE NUMBER and SMTP from Address book by searching with User ID?

Actually i have a list of User IDs (U123456, U132154.......) in my MS excel sheet. i want a macro which may help me to extract the details of this User ID details (given above) from address book to excel.

Note: this User ID has to be search in ALIAS field on address book. i have 150 User ID's in excel at the moment and wanted to get DISPLAY NAME, PHONE NUMBER and SMTP of them in return

can you please help me?

many thanks in advance.
Anish
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC