'%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)
How to Fix Excel VBA Outlook Automation Errors in Microsoft 365
Question details
The user's Excel VBA macro fails to create an Outlook application or email object after upgrading to Microsoft 365.
- Product
- Microsoft Excel and Outlook
- Device & OS
- Windows
- Scenario
- Running a VBA macro to automate sending emails or interacting with Outlook directly from an Excel spreadsheet.
- Observed behavior
- The macro stops executing and throws an automation error when attempting to run the CreateObject code to instantiate Outlook.
Ensure that both Microsoft Excel and Microsoft Outlook are fully installed on the same Windows computer. VBA macros are only supported on desktop versions of Office, not on Android, iOS, or web platforms.
Verify and Fix VBA Object Library References
Updating broken or missing Object Library references is the most common fix when VBA macros stop working after a Microsoft 365 upgrade.
When upgrading to Microsoft 365, the version number of the Outlook Object Library may change. If your Excel file was saved with an older reference, the macro will fail to locate the necessary components to create the Outlook object.
Press Alt + F11 on your keyboard while in Excel to open the Visual Basic for Applications (VBA) editor.
In the top menu bar, click on 'Tools' and select 'References' from the dropdown menu.
Scroll through the list and look for any item that starts with 'MISSING: Microsoft Outlook'. Uncheck the box next to this missing reference.
Scroll down the list to find the active 'Microsoft Outlook 16.0 Object Library' (or the version corresponding to your Microsoft 365 installation), check its box, and click 'OK'.
Switch from Early Binding to Late Binding
Using late binding allows your VBA code to dynamically discover the Outlook application, bypassing version-specific library errors.
Repair Office Installation and Verify Bitness
Mixed bit versions (32-bit vs. 64-bit) or corrupted Microsoft 365 updates can prevent Excel from communicating with Outlook.
Experience Stable Spreadsheet Automation with WPS Office
If frequent Microsoft 365 updates are causing compatibility issues with your VBA macros, consider switching to WPS Office. It provides a free, lightweight, and highly compatible alternative with excellent support for Excel formats and advanced spreadsheet functions.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package.
- 2. Install WPS Office: Run the installer and follow the on-screen prompts to set up the software on your Windows PC.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx or .xlsm files to continue your work without missing a beat.
Frequently Asked Questions
Why does my VBA macro say 'ActiveX component can't create object'?
This error typically means Excel cannot find or launch the Outlook application. It can happen if Outlook is not installed natively on your desktop, if there is a version mismatch between Excel and Outlook, or if aggressive antivirus software is blocking the script execution.
Can I run Excel VBA macros with Outlook on an Android device?
No, VBA macros are not supported on Android, iOS, or web versions of Microsoft Office. Automation scripts require a full desktop installation of Excel and Outlook on a Windows or macOS operating system.
How do I fix 'Missing Reference' errors in Excel VBA?
Press Alt + F11 to open the VBA editor, click on 'Tools' in the top menu, and select 'References'. Scroll through the list, uncheck any items explicitly marked as 'MISSING', and manually check the active versions of those libraries for your current Office installation.
