Fix an Excel Worksheet Change Macro That Does Not Display an Outlook Email
Question details
The user needs an Excel Worksheet_Change macro to display an Outlook email when a date is entered in column T.

- 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.
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.
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.
Right-click the relevant worksheet tab, select View Code, and locate its Worksheet_Change procedure.
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.
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.
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.
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.

Check Excel events, macro permissions, and Outlook availability
Use these checks if the breakpoint is never reached or Outlook cannot be created.
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.

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.




