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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Link Exchange/Outlook Contact Items

Status
Not open for further replies.

hchen

Programmer
Nov 22, 2001
9
GB
Hi, I have got a problem when I tried to link Outlook 2000 Contact Items from Access 2000. I want to get contact's address from Outlook, which is used in Access. I used File>Get External Data>Link Tables. Select Exchange in 'Files of Type' and then select a public folder (contacts). But, at last step, I have got error message "The MAPI store 'Folder name' is known but is not available in the current profile. This can occur if you use a profile that is designed for working offline from a sever and try to link a folder or address book on the server. The wizard is unable to link it."

Then I add this folder to "Public Folders/Favorites", and try to link anain, it works. But when I open the linked table in Access I found the table contains only all fields for Inbox (IPM.Note), not for Contacts (IPM.Conact) although the folder is contact folder and the message class displayed in the linked table is IPM.contact (it can seen from the linked table).

Therefore, please could you give any comments on these problems. 1)Access can not link a public contact folder; 2)when linked to a contact folder in Favorites, the linked table contains different fields.
 
Contact Folders are not directly accessable via MAPI, but by Outlook itself. MAPI treats contacts as messages, hence why the fields that visible look like message fields.

The data you require is hidden, but can be accessed by using CDO & MAPI coding. Have a look at it may have the code for you to copy/download, failling that i've found his book CDO & MAPI Programming with Visual Basic very useful.

Hope this helps

Craig Down
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top