Excel VBA Notify/Email when specific data entered

M

mike90

New Member
Joined
Jun 2, 2011
Messages
16
Hi,

I have a worksheet on Excel recording complaints. Each complaint is assinged a severity level T1 to T7 (T1 being the most serious). The problem I have is that I need to create some coding so that when a T1 case is entered, an email notifies the required people.

Can anyone help?
 
Sort by date Sort by votes
Tevor that is fantastic, thanks ever so much for your help!!! everything is running beautifully :D!!!
 
Upvote 0

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Pleased to read you have a working solution Mike, happy to help.;)
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
VBA Code to put hyperlink into email
Replies
4
Views
617
Micron
M
V
  • Question
Excel for Mac 2021 v16.81. Send bulk email with an attachmen
Replies
2
Views
326
vk2023
V
zookeepertx
  • Question
Having trouble "deciphering" some code so I can see how it works
Replies
7
Views
129
zookeepertx
zookeepertx
E
  • Question
Split Workbook VBA w/Default Value for Sensitivity Labels
Replies
1
Views
456
Jeffrey Mahoney
Jeffrey Mahoney
ExcelNewbie2020
  • Solved
Vba code to run subroutine in a specific time
Replies
6
Views
252
ExcelNewbie2020
ExcelNewbie2020

Forum statistics

Threads
1,216,028
Messages
6,128,393
Members
449,446
Latest member
CodeCybear

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top