Susan Harkins
ssharkins at gmail.com
Sun Nov 11 17:41:13 CST 2007
In the following code, the Set itm = itms.Add("IMP.Contact") statement returns an object variable not set error. The Outlook library is referenced. Any help?
Susan H.
Dim itms As Outlook.Items
Dim itm As Outlook.ContactItem
Set cnn = CurrentProject.Connection
rst.Open "tblContacts", cnn
Set itm = itms.Add("IMP.Contact")
With itm
.CustomerID = Nz(rst!CustomerID)
.FirstName = Nz(rst!FirstName)
.LastName = Nz(rst!LastName)
.Department = Nz(rst!Department)
.Birthday = Nz(rst!Department)
End With