Fix Excel VBA Email Automation Error After Windows 10 Upgrade
Question details
An Excel VBA email macro needs troubleshooting after an upgrade from Windows 10 version 1709 to version 1809.

- Product
- Microsoft Excel VBA
- Device & OS
- Windows 10 version 1809
- Scenario
- A macro reads email details from a worksheet and uses Internet Explorer to navigate to a Microsoft Online authentication URL before sending messages.
- Observed behavior
- The macro returns Automation Error -2125463506 (8150002e) when Internet Explorer navigates to the authentication URL.
Identify the worksheet columns used for recipients, copies, attachments, subject, and body, and confirm which account normally sends the messages. If you are unfamiliar with VBA, ask the macro owner or an IT administrator to help review the authentication code.
Debug the Internet Explorer authentication code
Use this approach to identify the failing statement and check whether the existing browser-based workflow can still authenticate.
The reported error occurs during navigation, but the code alone does not establish its cause. Internet Explorer is retired, and Microsoft Online authentication requirements may make legacy browser automation unreliable.
In Excel, open the workbook and press Alt+F11. In the Project pane, locate the module that creates Internet Explorer or calls its Navigate method.
Set a breakpoint on the navigation statement with F9, run the macro, and use F8 to step through the code. Record the highlighted statement and any displayed error number without sharing passwords or authentication tokens.
Inspect the Navigate call and the code that waits for the page or handles sign-in. Ask your IT administrator whether the account and authentication service still support the browser-based flow used by the macro.
In Excel, select File > Account > Update Options > Update Now. In Windows, open Settings > Update & Security > Windows Update and check for updates; plan an upgrade to a supported Windows version if necessary.
Have a VBA developer review the procedure's On Error handling and log Err.Number and Err.Description around the failing call. Run a controlled test to see whether the failure persists after updates.

Replace browser-based email automation with Outlook VBA
Use this alternative if classic Outlook is installed and configured with the sending account, and the organization permits Outlook automation.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Excel formats, making it easier to move everyday spreadsheet work between suites. It does not fix Excel's Internet Explorer automation error, and VBA macro compatibility should be tested separately.

Frequently Asked Questions
Why does the macro fail at the Microsoft Online sign-in URL?
The error occurs while Internet Explorer navigates to the authentication URL, but the exact cause needs investigation. Legacy Internet Explorer automation may no longer work with current authentication requirements; use Alt+F11 and F8 to identify the failing statement and ask your administrator to review the sign-in flow.
Will updating Windows and Office fix the error?
Updates are worth checking but are not a guaranteed fix. Use File > Account > Update Options > Update Now in Excel and Settings > Update & Security > Windows Update in Windows. A workflow that relies on retired Internet Explorer components may still need replacement.
Can Excel create emails without automating Internet Explorer?
Yes. A VBA developer can use classic Outlook automation to create messages from worksheet values, provided Outlook is installed, the account is configured, and organizational policies permit it. Use Display to review test messages before sending.
Can I use the new Outlook for Windows with the same VBA code?
Do not assume the existing Outlook COM automation will work in the new Outlook for Windows. The Outlook VBA alternative described here requires classic Outlook; check your organization's supported email automation options if classic Outlook is unavailable.
Will WPS Office fix the Excel VBA authentication error?
No. WPS Office can open and edit common Excel workbook formats, but it does not repair Microsoft Excel's Internet Explorer automation. Test any VBA-dependent workbook separately before relying on it in another office suite.




