Fix Excel VBA Outlook Mail Display After an Office Upgrade
Question details
The user needs an Excel VBA macro to display an Outlook email after upgrading from Office 2013 to Office 2019.

- Product
- Microsoft Excel 2019 and Outlook
- Device & OS
- not provided
- Scenario
- An Excel VBA macro creates an Outlook email for the user to review.
- Observed behavior
- The email window may not appear after the Office upgrade, even though no error is shown.
Confirm that desktop Outlook is installed, configured with a mail profile, and can open normally. Open the workbook in desktop Excel and locate the macro that creates the message.
Call the Outlook mail item's Display method using late binding
Use this approach to create and display a message without relying on a version-specific Outlook object library reference.
In Excel, press Alt+F11 to open the VBA editor, then locate the procedure that creates the Outlook message.
Declare both variables as Object and create the application and mail item: Dim objOutlook As Object, objMail As Object; Set objOutlook = CreateObject("Outlook.Application"); Set objMail = objOutlook.CreateItem(0). Put each statement on its own line in the VBA editor.
After setting any message properties, add objMail.Display on its own line. Run the macro from Excel's Developer > Macros dialog or from the VBA editor.
If no message appears, open Outlook and check for a message window behind Excel. In the VBA editor, review any On Error Resume Next statements that may be hiding an error, then run the macro again.

Check Outlook references used by early-bound VBA code
Use this check if the macro declares variables with Outlook-specific types or if the VBA project has a missing reference.
Work with Excel Workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office files. Its spreadsheet format support can make migration easier, but it does not fix Outlook's VBA Display method; test macros and Outlook integration before relying on them.

Frequently Asked Questions
Why does my macro create an Outlook item but show no email window?
Creating the item with CreateItem(0) does not display it. Add objMail.Display after setting the message properties, then run the macro again.
What does late binding change in the macro?
Late binding declares Outlook variables as Object and uses CreateObject("Outlook.Application"), avoiding a dependency on a specific Outlook object library reference. Outlook must still be installed and accessible.
Where can I find a missing Outlook reference?
Press Alt+F11 in Excel and choose Tools > References. Look for a reference marked MISSING and replace it with an available Outlook object library if the code uses Outlook-specific types.
Will Display send the email automatically?
No. The mail item's Display method opens the message for review. Sending requires a separate action.




