Susan Harkins
ssharkins at gmail.com
Mon Nov 12 16:16:23 CST 2007
I posted the following code on the tech list this weekend, but so far haven't resolved the problem I'm having. I'm trying to send Access values to Outlook as a new contact. The Set itm = itms.Add("IPM.Contact") statement returns a can't set object variable error.
Susan H.
Function SendContactsToOutlook()
Dim rst As New ADODB.Recordset
Dim cnn As New ADODB.Connection
'---------
'Must set reference to Outlook library
'---------
Dim itms As Outlook.Items
Dim itm As Outlook.ContactItem
Set cnn = CurrentProject.Connection
rst.Open "tblContacts", cnn
'Outlook Folder name is hardcoded
Set itm = itms.Add("IPM.Contact")
With itm
.CustomerID = Nz(rst!CustomerID)
.FirstName = Nz(rst!FirstName)
.LastName = Nz(rst!LastName)
.Department = Nz(rst!Department)
.Birthday = Nz(rst!Department)
.Close (olSave)
'DoCmd.RunCommand acCmdSaveRecord
End With
Set rst = Nothing
Set cnn = Nothing
Set itms = Nothing
Set itm = Nothing
End Function