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

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