Export contact from Access

[Guest]

Writing code to export name, address, other info, etc. from an Access 2003
database into Outlook 2003. Code works fine so far, except for getting info
from database into the Notes field on a new Outlook contact.

I am creating variables through a command button on screen form in Acess
(i.e. Dim strHomePhone As String) then filling them by strHomePhone =
Nz(Me![HomePhone]). This works for all fields so far (firstname, lastname,
etc.) but I don't know the syntax for the notes field.

Two questions:
1. What is the code to reference notes field in Outlook contact? I assumed
I could use strNotes but that doesn't work.
2. Where can I find a list of all field names Outlook uses for contacts?

 

[Sue Mosher [MVP-Outlook]]

1) It's the Body property.

2) When in doubt, check the object browser in VBA. Press F2, then switch from <All Libraries> to Outlook to browse all Outlook objects and their properties, methods, and events (assuming you added a reference to Outlook in your Access project). Select any object, e.g. ContactItem, or member, then press F1 to see its Help topic.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers