VBA & Macro Problems

How to Fix Excel VBA Reminder Emails Not Sending

Ayan MasoodAyan Masood Nov 2, 2026 870 views

Question details

The user needs to fix an Excel VBA procedure that runs endlessly without sending Outlook reminder emails or displaying any error messages.

How to Fix Excel VBA Reminder Emails Not Sending
Product
Microsoft Excel
Device & OS
not provided
Scenario
Automating Outlook email reminders for worksheet tasks that have been open for seven days or longer.
Observed behavior
The macro enters a long-running execution state (often hours) without successfully creating the emails or triggering a VBA runtime error.
Before you start

Before debugging the code, ensure Microsoft Outlook is currently open and configured with a default email account, and press 'Esc' or 'Ctrl + Break' on your keyboard to halt the currently running infinite VBA loop.

Solution 1Recommended

Interrupt the Infinite Loop and Add Error Handling

Stop the macro from running endlessly and implement basic VBA error catching to identify the exact point of failure.

When a macro runs for hours without action or failure, it is typically caught in an infinite loop or silently skipping execution steps due to suppressed errors. You must force the code to stop and enable error reporting.

1
Halt the macro execution

Press the 'Esc' key or 'Ctrl + Break' on your keyboard multiple times until the VBA execution is interrupted and the debugging prompt appears.

2
Remove silent error suppression

Search your VBA code for 'On Error Resume Next'. If present, comment it out by adding an apostrophe (') at the beginning of the line. This ensures errors are not hidden.

3
Implement an Error Handler

Add 'On Error GoTo ErrorHandler' at the start of your procedure. At the end of the code, add 'ErrorHandler: MsgBox Err.Description' to display the exact issue preventing the emails from sending.

Interrupt the Infinite Loop and Add Error Handling
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

While you troubleshoot complex Microsoft Excel VBA scripts, consider using WPS Office for your daily tasks. It is a highly compatible, free alternative that offers intuitive tools for managing data without heavy reliance on macros.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free to use with a familiar, user-friendly interface.Fast installation and low system resource consumption.Built-in robust data processing and automation tools.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel macro run endlessly without doing anything?

This usually happens when a 'Do While' loop lacks a proper exit condition, or an iterating variable fails to increment, causing an infinite loop. Press 'Ctrl + Break' to manually stop the execution.

Do I need Outlook open to send VBA emails?

Yes, typically when using 'Outlook.Application' objects in VBA, having the Outlook desktop client open and configured with an active default profile is required to successfully dispatch the emails.

How do I see errors in VBA instead of the macro failing silently?

Ensure you haven't used 'On Error Resume Next' globally without explicitly handling the errors. Remove or comment out this line, and implement a proper 'On Error GoTo' handler to catch and display the specific error message.

Can I automate email reminders without using VBA?

Yes. You can use Power Automate (formerly Microsoft Flow) to trigger email reminders based on Excel data conditions—such as tasks open for more than seven days—without writing complex VBA code. Your Excel file must be stored on OneDrive or SharePoint.