Hello all,
I was wondering if anyone could help. I have the following code which for about 4 years has worked flawlessly to connect access to Outlook. The last couple of weeks it has been failing on the CreateObject line and I can't for the life of me work out why. Does anyone have any ideas? Has anything changed in Windows that could be affecting this? Are there any other ways I can connect to outlook?
If you have any thoughts, I would appreciate your help. I have already tried a compact and repair of the database.
Code:
Dim oApp As Outlook.Application
Set oApp = CreateObject("Outlook.Application")
' Rest of the code
Thanks