Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Downloading Outlook data - Office Number

Status
Not open for further replies.

Wrathchild

Technical User
Aug 24, 2001
303
US
Hi, I'm trying to download personnel from Outlook and it's working fine but I can't seem to get Office Number from the entries. I'm using the code below but I don't know what the number(&H3A19001E-something like that) would be for office number.

Option Compare Database
Option Explicit

Const CdoPR_OFFICE_LOCATION = &H3A19001E
Const CdoPR_TITLE = &H3A17001E
Const CdoPR_DEPARTMENT_NAME = &H3A18001E
Const CdoPR_DISPLAY_NAME = &H3001001E
Const CdoPR_EMAIL_ADDRESS = &H3003001E
Const CdoPR_ORGANIZATIONAL_ID_NUMBER = &H3A10001E
Const CdoPR_OFFICE_NUMBER = ?????????????
....
EmailName = AddrEntry.Fields(CdoPR_EMAIL_ADDRESS).Value
strDisplayName = AddrEntry.Fields(CdoPR_DISPLAY_NAME).Value
strTitle = AddrEntry.Fields(CdoPR_TITLE).Value
etc...

 
I figured it out...in case anyone is wondering:

There are customizable fields in Outlook, which is where the office number I was looking for was. This page has a list of the custom cdo attributes

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top