Automation error (1 Viewer)

Gasman

Enthusiastic Amateur
Local time
Today, 04:10
Joined
Sep 21, 2011
Messages
14,287
Hi all,

I appear to have had some sort of windows update which now stops me sending emails from Access.?

The code is falling over at

Code:
 Set OutApp = CreateObject("Outlook.Application")
with the error attached.

What do I need to correct to get it all working again please?
I have Macro Security set to No security checks for macros and programmatic access. changed to never warn (was Always warn).

TIA

Edit: UAC is set to Never notify and has always been
 

Attachments

  • Automation.PNG
    Automation.PNG
    6.3 KB · Views: 127
Last edited:

Gasman

Enthusiastic Amateur
Local time
Today, 04:10
Joined
Sep 21, 2011
Messages
14,287
OK,
It appears to be something linked to a shortcut I created to be able to open outlook templates without being prompted all the time. To do this I have to start Outlook with administraor priviliges and take the tick out of the prompt, then start as normal.

I cleared the checkbox Runs as Administrator and it now works again as it should.
 

Users who are viewing this thread

Top Bottom