| | |
How to get Outlook address book details to MS excel?
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
![]() |
•
•
Join Date: Jun 2009
Posts: 1
Reputation:
Solved Threads: 0
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
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
![]() |
Similar Threads
- Need help with recovery of Outlook address book (WAB)! (Windows NT / 2000 / XP)
- VB6 - Look up email address from outlook address book? (Visual Basic 4 / 5 / 6)
- VB 6.0 - Accepting value (email address)from Inputbox (Visual Basic 4 / 5 / 6)
- How to suppress the Outlook Address Book Securtiy Pop up box ? (VB.NET)
- Outlook address book (Windows NT / 2000 / XP)
- error when opening outlook express, address book and importing messages to outlook (Windows NT / 2000 / XP)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: how to change DTpicker am/pm in codes?
- Next Thread: linking two combo boxes
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows





