VBA & Macro Problems

Fix Excel VBA Outlook Mail Display After an Office Upgrade

Nimra MalikNimra Malik Nov 22, 2026 868 views

Question details

The user needs an Excel VBA macro to display an Outlook email after upgrading from Office 2013 to Office 2019.

Fix Excel VBA Outlook Mail Display After an Office Upgrade
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the macro

In Excel, press Alt+F11 to open the VBA editor, then locate the procedure that creates the Outlook message.

2
Create the Outlook objects

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.

3
Display the message

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.

4
Check Outlook and errors

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.

Call the Outlook mail item's Display method using late binding
Review before sending: Display opens the message for review; it does not send the email.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet tools to work with existing workbooksWork with documents, spreadsheets, and presentations in one lightweight suiteStart using WPS Office for free
microsoft office alternative - wps office

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.