troubleshooting Question

outlook 2013 ms access

Avatar of hgj1357
hgj1357 asked on
Microsoft Access
22 Comments1 Solution240 ViewsLast Modified:
I was using the following code within MS Access 2003 (XP) to pipe contact data into Outlook.  Worked great with Outlook 2003 and Outlook XP. It does not work with Outlook 2013.  Is there an easy fix for this, or is it more involved?

 Set OlkApp = New Outlook.Application
   With OlkApp
      Set olkCon = .CreateItem(Outlook.OlItemType.olContactItem)
      With olkCon

.BusinessTelephoneNumber = strBusinessTelephonenumber
.HomeTelephonenumber = strHomeTelephonenumber
.MobileTelephoneNumber = strMobileTelephonenumber
.BusinessFaxNumber = strBusinessFaxNumber
.Email1Address = strEmail1Address
.JobTitle = strJobTitle
.CompanyName = strCompanyName
.FirstName = strFirstname
.LastName = strLastname
.BusinessAddressStreet = strBusinessAddressStreet
.BusinessAddressCity = strBusinessAddressCity
.BusinessAddressState = strBusinessAddressState
.BusinessAddressPostalCode = strBusinessAddressPostalCode

                Forms![Main F]![MainSub].Form![Command178].SetFocus
                Forms![Main F]![MainSub].Form![Contacts_Corr_Pick].Visible = False

      End With
   End With
   ' Clean up.
   Set OlkApp = Nothing
   Set olkCon = Nothing

Fails here:  "   Set OlkApp = New Outlook.Application"
Join our community to see this answer!
Unlock 1 Answer and 22 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 22 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros