Why is MS always the troublemaker.
I use the attached code for late binding in order to avoid differences in versions of the reference to outlook.
It is used in an access front-end-application, local installed on several workstations (3) with different office versions. The backend mdb is on a server. There is no reference to outlook when the code starts running.
At home on a laptop this code works fine. But not on the 3 workstations: automation error on the createobject line. What is wrong
Dim myolApp As Object
Dim MyItem As Object
'Specify error handler
On Error GoTo SMError
Set myolApp = CreateObject("Outlook.Application")
Set MyItem = myolApp.CreateItem(olMailItem) 'olMailItem