VBA & Macro Problems

Fix an Excel Worksheet Change Macro That Does Not Display an Outlook Email

Ayan MasoodAyan Masood Nov 18, 2026 870 views

Question details

The user needs an Excel Worksheet_Change macro to display an Outlook email when a date is entered in column T.

Fix an Excel Worksheet Change Macro That Does Not Display an Outlook Email
Product
Microsoft Excel VBA and Microsoft Outlook
Device & OS
not provided
Scenario
A user enters a date in column T and expects the worksheet event to create and display an Outlook email.
Observed behavior
The procedure exits without displaying an email or showing an error.
Before you start

Open the macro-enabled workbook in Excel and locate the worksheet where dates are entered. Use a test row with a valid date in column T and a nonempty related cell in column Q.

Solution 1Recommended

Step through the worksheet event and check its exit conditions

Use the VBA debugger to find which condition stops the macro before it creates the email.

1
Open the worksheet code

Right-click the relevant worksheet tab, select View Code, and locate its Worksheet_Change procedure.

2
Set a breakpoint

Click the first executable line in Worksheet_Change and press F9 to set a breakpoint. Return to the worksheet and enter a date in a single cell in column T.

3
Step through the checks

When execution pauses, press F8 to advance one line at a time. Inspect Target and the conditions around each Exit Sub to see which check causes the procedure to leave.

4
Verify the test values

In the worksheet, confirm that the edit changed only one cell, that the cell is in column T, that Excel recognizes its value as a date, and that column Q in the same row is not empty. Check each condition against the code as you step through it.

5
Check the email code

Continue with F8 to the CreateObject("Outlook.Application") line and the message's Display call. If error handling suppresses an error, inspect the relevant handler and error details before changing the code.

Step through the worksheet event and check its exit conditions
Display is not Send: The Outlook message's Display method opens the draft; it does not send the email. Sending requires a separate Send call or a manual action.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easier to move everyday workbook tasks between applications. It does not fix Excel's Outlook automation or guarantee compatibility with every VBA macro.

Open and edit spreadsheet data in a familiar interfaceCompatible with common Microsoft Excel formats, including XLSX and XLSMReview the dates and related row data used by your email workflowUse a free, lightweight office suite for everyday document tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does Worksheet_Change exit without an error?

An Exit Sub condition may be met, or error handling may suppress an error. Set a breakpoint in the worksheet's code module, edit a test cell, and press F8 to identify where execution leaves the procedure.

Why does the event not run when I edit column T?

Check that macros are enabled, that Worksheet_Change is in the edited worksheet's code module, and that Application.EnableEvents is True in the VBA Immediate Window.

Will a formula changing its result trigger Worksheet_Change?

No. A result changing only because of recalculation does not trigger Worksheet_Change. A calculation-driven workflow may need Worksheet_Calculate and additional logic to detect the relevant change.

How can I tell whether Outlook can be created from VBA?

On a supported Windows setup with classic Outlook installed and configured, open View > Immediate Window in the VBA editor and enter ?TypeName(CreateObject("Outlook.Application")). An error indicates that Outlook automation needs further investigation.

Does displaying an Outlook message send it automatically?

No. The Display method opens the message for review. The user must send it manually, or the code must use a separate Send call.