Help, experts needed! Auto notification
I have an excel spreadsheet with five columns. On column D I have a drop
down list with four choices ("n/a" , "Grp1" , "Grp2" , "Grp3"). When a row is filled in, one of the four choices in column D has to be choosen. When the user exits the spreadsheet an email is automatically sent to three different individuals based on what was choosen in column D. I.E. If "Grp1" was choosen person A, B, and C gets and email notifying them that they need to do something. When "Grp2" is choosen then person D, E, F are notified. And so on. Does anyone know how I can do this? Help help help! Melanie |
Auto notification
Guess this one is a stumper? Does anyone have any idea where/how I can start?
Thanks, Melanie -- Melanie "Melanie" wrote: I have an excel spreadsheet with five columns. On column D I have a drop down list with four choices ("n/a" , "Grp1" , "Grp2" , "Grp3"). When a row is filled in, one of the four choices in column D has to be choosen. When the user exits the spreadsheet an email is automatically sent to three different individuals based on what was choosen in column D. I.E. If "Grp1" was choosen person A, B, and C gets and email notifying them that they need to do something. When "Grp2" is choosen then person D, E, F are notified. And so on. Does anyone know how I can do this? Help help help! Melanie |
All times are GMT +1. The time now is 07:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com