Unanswered: Importing MS Outlook Contacts from a MSAcess Data Base
I need to get information from a MSAccess DB that i've made.
I have 2 forms. The main form has the following fields: Foto, Name and Birthday. The subform has the following fields: address, mobile phone, email.
I want to store into the field Mobile_Phone the information of Tlm (this is the field from the subform Contactos inserted in the Main Form).
I wrote the following code:
Dim olns As Object ' Outlook Namespace.
Dim cf As Object ' Contact folder.
Dim c As Object ' Contact item.
Dim ol As New Outlook.Application
Set olns = ol.GetNamespace("MAPI")
Set cf = olns.GetDefaultFolder(olFolderContacts)
' Create a new Contact item.
Set c = ol.CreateItem(olContactItem)
' Specify which Outlook form to use.
c.MessageClass = "IPM.Contact"
c.FullName = Me.Nome -> this line works OK
c.Mobile_Phone = Contactos!Tlm -> this one does't work
What seems to be the problem?It has something to do with field types? Where can i get that information? Please help me!