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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
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
685
Micron
M
V
  • Question
Excel for Mac 2021 v16.81. Send bulk email with an attachmen
Replies
2
Views
360
vk2023
V
E
  • Question
Split Specific Sheets into New Excel Workbook and email to different people
2 3
Replies
23
Views
376
Excel2021
E
A
  • Question
Excel data from one sheet, copy cells from row i'm working on to excel 'form' based on cell value
Replies
2
Views
158
asiuol84
A
zookeepertx
  • Question
Having trouble "deciphering" some code so I can see how it works
Replies
7
Views
183
zookeepertx
zookeepertx

Forum statistics

Threads
1,216,727
Messages
6,132,354
Members
449,720
Latest member
NJOO7

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