'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel VBA Macros Not Working in New Outlook
Question details
Users are unable to execute Excel VBA macros that automate email creation or interact with Microsoft Outlook after updating to the New Outlook client.
- Product
- Microsoft Excel and New Outlook
- Device & OS
- not provided
- Scenario
- Attempting to run existing Excel VBA macros that rely on 'Outlook.Application' and 'CreateItem' to generate and send emails.
- Observed behavior
- The VBA macros fail to run and return errors because the New Outlook does not support the COM-based Outlook object model required by traditional VBA scripts.
Verify whether your Excel macro relies specifically on COM add-ins or the 'Outlook.Application' object model, and ensure you have permission to switch Outlook versions or access Power Automate.
Revert to Classic Microsoft Outlook
The quickest and most reliable fix for existing VBA macros is to toggle back to the classic version of Outlook, which fully supports COM add-ins and VBA automation.
Because New Outlook is a web-based application, it inherently lacks support for the traditional VBA Outlook object model. Switching back to Classic Outlook restores this functionality instantly without requiring you to rewrite your macros.
Launch the New Outlook application on your desktop.
Look for the 'New Outlook' toggle switch, typically located in the top right corner of the application window.
Click the toggle to turn it off. The application will prompt you for feedback, close, and then reopen in the classic Outlook view.
Open your Excel workbook and execute your VBA macro again. The COM-based Outlook automation should now function perfectly.
Migrate to Modern Automation Alternatives
If you must continue using New Outlook, you will need to replace your traditional VBA scripts with modern, web-supported automation methods.
Experience Seamless Spreadsheet Management with WPS Office
If you are frustrated by compatibility changes and deprecated features in other office suites, consider switching to WPS Office. It provides a lightweight, highly compatible, and intuitive environment for all your spreadsheet and document needs without the hassle of unexpected architecture overhauls.
Frequently Asked Questions
Will New Outlook ever support VBA COM add-ins?
Currently, Microsoft has stated that New Outlook is fundamentally web-based and will not support COM add-ins or the traditional VBA Outlook object model. Users are encouraged to transition to web add-ins and modern APIs.
Do I need to rewrite my Excel macros completely?
If you simply switch back to Classic Outlook, no changes are needed to your existing macros. However, if you plan to exclusively use New Outlook, you must replace the VBA email automation code with alternatives like Power Automate or Office Scripts.
Can I still use basic 'Mailto' hyperlinks in Excel with New Outlook?
Yes, basic 'mailto:' hyperlinks in Excel still function with New Outlook to open blank or templated draft emails. However, they cannot automatically send the emails or attach files silently in the background like VBA can.
