New Outlook Does Not Support VBA Macros: Practical Alternative

The new Outlook for Windows does not support VBA macros. This means scripts you built to automate email sorting, message replies, or calendar tasks will not run in the new app. Microsoft designed the new Outlook on a web-based platform that cannot load the COM add-in model VBA requires. This article explains why VBA is missing in the new Outlook and provides concrete alternatives to achieve the same automation results.

Why the New Outlook Cannot Run VBA Macros

The new Outlook is built on Microsoft’s web-based platform used by Outlook on the web and Outlook for Mac. This platform uses a different runtime environment that does not include the Visual Basic for Applications engine. VBA macros rely on COM add-ins and the Outlook object model, which are not present in the new Outlook’s architecture. Microsoft has stated that VBA will not be added to the new Outlook. Instead, the company recommends using Power Automate, add-ins, and built-in rules to achieve similar automation. The new Outlook also does not support COM add-ins, meaning any third-party tool that depends on COM will not load.

Practical Alternatives to Replace VBA Macros in the New Outlook

You have three main paths to replace VBA macros: cloud automation with Power Automate, built-in tools such as Quick Steps and rules, and third-party add-ins from AppSource. Each method works for different scenarios.

Power Automate Cloud Flows

1. Open Power Automate in your browser
   Go to make.powerautomate.com and sign in with your Microsoft 365 work or school account.
2. Create a new automated cloud flow
   Select Create > Automated cloud flow. Choose a trigger such as When a new email arrives in Outlook.
3. Add an action from the Outlook connector
   Click New step and search for Outlook. Select an action like Move email, Forward email, or Create calendar event.
4. Configure the action parameters
   Set the folder, subject filter, or recipient address. Use dynamic content from the trigger to insert email properties.
5. Save and test the flow
   Click Save, then Test. Send a test email to verify the flow runs correctly.

Quick Steps in the New Outlook

1. Open Quick Steps from the Ribbon
   In the new Outlook, go to the Home tab and click Quick Steps in the Move group.
2. Create a new Quick Step
   Select New Quick Step and choose from templates such as Move to Folder, Reply and Delete, or Forward.
3. Customize the action
   Set the destination folder, message text, or flag options. You can add multiple actions in one Quick Step.
4. Assign a keyboard shortcut
   In the Quick Step editor, set a shortcut key combination like Ctrl+Shift+1 to trigger the step.
5. Apply the Quick Step to any email
   Select a message and click the Quick Step name or press the keyboard shortcut.

Install Third-Party Add-ins from AppSource

1. Open Get Add-ins in the new Outlook
   Click the ellipsis (…) on the ribbon and select Get Add-ins.
2. Browse or search for automation tools
   Use the search bar to find add-ins like Shared Email Templates, Auto Reply Manager, or Email Automation.
3. Review permissions and install
   Click an add-in, read the permissions, and select Add. The add-in appears in the ribbon after installation.
4. Configure the add-in for your workflow
   Open the add-in from the ribbon and set up templates, rules, or triggers according to the vendor’s instructions.

If the Alternative Does Not Work as Expected

Switching from VBA to these alternatives may reveal gaps in functionality. Below are specific problems and their fixes.

Power Automate Flow Fails to Trigger on Some Emails

Power Automate triggers only on emails that arrive after the flow is saved. Emails already in the inbox are ignored. To process existing messages, add a manual trigger or use a scheduled flow that runs on a recurring basis. Also verify that the mailbox is connected to the same Microsoft 365 account used in Power Automate.

Quick Step Does Not Appear in the Ribbon

Quick Steps in the new Outlook are stored per mailbox profile. If you switch between the new Outlook and classic Outlook, Quick Steps may not sync. Recreate the Quick Step in the new Outlook directly. Also confirm that you are using the new Outlook version 1.2023.xxx or newer, as earlier builds had limited Quick Step support.

Third-Party Add-in Does Not Work After Installation

Some add-ins require the classic Outlook COM add-in model and will not load in the new Outlook. Check the add-in’s AppSource listing for a note that says Works with new Outlook. If the add-in is not compatible, contact the vendor for a web-based version. As of 2025, most major add-in providers have released new Outlook-compatible versions.

Power Automate vs Quick Steps vs Add-ins: Comparison

Item	Power Automate	Quick Steps
Trigger type	Event-based (new email, calendar change)	Manual (user clicks or keyboard shortcut)
Complexity	High – requires flow design and condition logic	Low – set-and-forget single or multi-step action
Requires coding	No coding, but logical condition building	No coding
Works offline	No – requires internet connection	Yes – runs locally in the Outlook client
Best for	Automated email routing, approval workflows, calendar sync	One-click move, reply, flag, or delete on individual messages

The new Outlook does not support VBA macros, but Power Automate, Quick Steps, and third-party add-ins can replace most common automation tasks. Power Automate handles complex event-driven workflows. Quick Steps work for manual one-click actions on individual messages. Add-ins fill specialized needs such as email templates or auto-reply scheduling. Evaluate which method matches each automation task you previously handled with VBA. For advanced automation that requires custom code, consider using Microsoft Graph API with a script running outside Outlook.