No longer able to connect to Outlook

[Robyn_P]

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.

Dim oApp As Outlook.Application
Set oApp = CreateObject("Outlook.Application")

' Rest of the code

Thanks

[Welshgasman]

No error message?

[ranman256]

Is outlook open before you run it? Open it.