Is it possible to run VBA scripts upon startup with Outlook

Question

I am trying to do the following:

Move Emails on a Schedule from one folder to another.

So far, I have the macro that moves the emails. However, I am not sure how to initiate this automatically. Copilot told me I can make a .vbs that with MS Scheduler will be able to move the emails on a schedule

Dim objOutlook

outlookApp.Session.Logon

outlookApp.Application.Run "MoveEmails"

Set outlookApp = Nothing.

I get error code 800A01B6 object doesn't support this property or method. Is there any way to move emails on a schedule, either by scheduled task or other means?

Answer 1

Copilot was hallucinating. Unlike other Office apps, there is no "Application.Run" method in Outlook.

As far as I know, Outlook Security has pretty much blocked the ability to run a Macro from outside of Outlook. One method I've used in the past, was to add the Macro to the Quick Access Toolbar and then use a scripting tool like AutoIt to "Send" keystrokes to a running, visible, Outlook session to execute the Macro. e.g. "{Alt Down} {Alt Up} 1" will execute the first item on the QAT.

You might be better off using something other than an Outlook macro. Any office app that lets you use CreateObject("Outlook.Application") (e.g. Excel) can then do pretty much the same thing your Macro did, using almost identical VBA code. There are lots of other options. Scripting languages that support Outlook Automation (e.g. AutoIt) and C# using the Outlook Interop libraries.