|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
June 30th 06, 12:17 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Extract Outlook Address book properties into Excel
Thanks Sue,
Will try that & let you know. Sue Mosher [MVP-Outlook] wrote: 1) IAddrBook 2) Switch to the GetSearchPath tab. Select GLobal Address Book and click OpenEntry. 3) Switch to the GetContentsTable tab. Select an entry that you has known data in the property you're interested in. Click OpenEntry. 4) Browse the Value column until you find the known data. That will be the property you want. Make note of that property's "Tag num" value at upper right. That is the MAPI property tag you need to use to extract that value programmatically from the AddressEntry.Fields collection. -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Junoon" wrote in message oups.com... Hi Sue, I had downloaded & installed Outlook Spy on my Office PC, but am still unable to Locate the "Emp.Code" field. Can you please provide some guidelines as to where to look for it on the Toolbar thats installed in MS Outlook now. Warm regards, Junoon Sue Mosher [MVP-Outlook] wrote: Data in the GAL is not Outlook contact data. You can use Outlook objects to get only the bare basics, like name and address (and not even the SMTP address at that). For other properties, you must use CDO 1.21 or, to avoid security prompts, Redemption. See http://www.outlookcode.com/codedetail.aspx?id=594 for a sample that shows how to return the mobile phone number from a GAL user entry. "Junoon" wrote in message oups.com... I think since the Employee names & Emp Code belongs to a Global Address list, so they donot come under User defined properties. What i tried to do was search for the Emp Code (Emp ID) by double-clicking on a mail address. The Emp Code shows under the "General" Tab but when i search for it in Contacts, Journals, User-defined fields etc, i am unable to locate it. 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Exporting my address book to excel | John Davy | Outlook - Using Contacts | 13 | May 18th 06 02:15 PM |
| Is it possible to Extract IP Address from the message headers of E-Mails in .PST file. | Niks | Outlook - General Queries | 3 | April 24th 06 02:12 PM |
| How can I extract share calender information to excel sheet | TILLYCHIPS | Outlook - Calandaring | 1 | April 17th 06 03:37 PM |
| Can someone open my old address book in Excel and email it to me | Shervision | Outlook - Using Contacts | 1 | March 1st 06 08:21 PM |
| how do I get my contacts from excel to show up in my address book | Houston Texas | Outlook - Using Contacts | 10 | February 22nd 06 01:07 AM |
Hybrid Mode
