VBA & Macro Problems

How to Send Outlook Alerts When an Excel Column Changes

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to set up an automated system in Excel that sends an email notification to specific Outlook recipients whenever a user manually edits a particular column.

Product: Microsoft Excel and Outlook
Device & OS: not provided
Scenario: Tracking data changes in a specific Excel column and automatically notifying stakeholders via email.
Observed behavior: Triggering an Outlook email automatically by utilizing a Worksheet Change event via VBA script in Excel.

Before you start

Ensure you have the desktop versions of both Microsoft Excel and Microsoft Outlook installed on your computer, as web versions do not support VBA macros.

Solution 1Recommended

Use a Worksheet_Change VBA Macro

Add a custom VBA script to your worksheet module to monitor a specific column and trigger an Outlook email upon modification.

By utilizing the Worksheet_Change event in VBA, Excel can automatically detect when specific cells are modified. Combined with Outlook's application object, you can seamlessly generate and send an email alert in the background.

Open the VBA Editor

In your Excel workbook, press ALT + F11 on your keyboard to open the Microsoft Visual Basic for Applications window.

Select the Target Worksheet

In the Project Explorer panel on the left, double-click the specific worksheet (e.g., Sheet1) where you want to track column changes. Do not place this code in a standard module.

Paste the VBA Code

Paste the `Private Sub Worksheet_Change(ByVal Target As Range)` script into the code window. Ensure you locate the line `.To = "recipient@example.com"` and replace it with the actual recipient's email address.

Save as a Macro-Enabled Workbook

Go to File > Save As. In the file format dropdown menu, select 'Excel Macro-Enabled Workbook (*.xlsm)' to ensure your VBA script is saved and can run.

Test the Trigger

Return to your Excel sheet and edit any cell in the monitored column (e.g., Column B). The macro will run and Outlook will send an email alert to the specified address.

Macro Security Settings: Macros may be blocked by default due to security settings. You may need to go to File > Options > Trust Center > Trust Center Settings > Macro Settings to enable VBA macros for this automation to function.

Advanced Data Management

Automate Your Worksheets with WPS Office

WPS Office offers robust spreadsheet capabilities with excellent Microsoft Excel compatibility. You can manage data efficiently, utilize advanced formulas, and leverage VBA (in supported premium versions) to automate your tasks seamlessly.

1. Download WPS Office: Download and install WPS Office from the official website.
2. Open Your Workbook: Open your existing .xlsm file or create a new WPS Spreadsheet.
3. Access Developer Tools: Navigate to the Developer tab (available in versions with VBA support) to access and manage your macros.
4. Run Automations: Use the familiar VBA editor to paste, edit, and run your automation scripts just like you would in Excel.

100% compatibility with Microsoft Excel formats (.xlsx, .xlsm)Lightweight software with significantly faster loading timesBuilt-in tabbed interface for managing multiple documents effortlesslyRich set of data analysis, visualization, and automation tools

microsoft office alternative - wps office

Frequently Asked Questions

Can I use this macro in Excel for the Web?

No, VBA macros are only supported in the desktop version of Excel. Excel for the Web does not support running, editing, or triggering VBA code.

How do I change the column being monitored in the VBA code?

In the VBA script, locate the line `Intersect(Target, Me.Columns("B"))`. Change the letter "B" to your desired column letter (e.g., "C" or "D") to monitor a different column.

Why is my Outlook email not sending automatically?

Ensure that the desktop version of Microsoft Outlook is installed, set up with an active email account, and properly configured. Additionally, check your macro security settings in Excel to ensure the script isn't being blocked by the Trust Center.

Excel & Data Problems