Runtime Error 429 - ActiveX Component cannot create Object
I have VBA code/macro in Excel that opens Outlook and emails a temporary saved copy of this Excel spreadsheet to a distribution list.
When I manually start the spreadsheet, it run without issue - generating emails via Outlook.
When I use MS Windows Task Scheduler to auto-start the same spreadsheet, I get the above error message trying to setup Outlook message,
Set OutApp = CreateObject("Outlook.Application")
|