Outlook 2010 CONTACTS linking - NOTES FIELD

[nola]

Hello everyone. I know how to create new table in Access by linking to Outlook contacts. The problem is, the default NOTES field in the Outlook contact does not show up in the linked Access table. Every Outlook Contact field shows up with the exception of that one field. I'm hoping, heck...I'm PRAYING that someone knows a way around this. Thanks in advance.

[ItsMe]

You will need to create VBA to interact with Outlook and get the info you want. The Outlook Object Library has plenty of properties and methods to use. The trick is creating code to get what you want.

' The Outlook object library must be referenced.
Dim ol As Outlook.Application
Dim olns As Outlook.NameSpace
Dim objFolder As Outlook.MAPIFolder
Dim AllContacts As Outlook.Items
Dim Item As Outlook.ContactItem

[nola]

You will need to create VBA to interact with Outlook and get the info you want. The Outlook Object Library has plenty of properties and methods to use. The trick is creating code to get what you want.

' The Outlook object library must be referenced.
Dim ol As Outlook.Application
Dim olns As Outlook.NameSpace
Dim objFolder As Outlook.MAPIFolder
Dim AllContacts As Outlook.Items
Dim Item As Outlook.ContactItem

Can you please "dumb" this down a lot? Not a VBA user.

[ItsMe]

Sorry, but that is the dumbed down version. I guess I could leave it at, you need to employ VBA.

You could use some of the declarations I provided as search terms for VBA examples. Bottom line, you will need intermediate to advanced VBA skills. I don't believe the wizard cares about the notes field.