software

I have an excel spreadsheet with five columns. On column D I have a drop
down list with four choices (quot;n/aquot; , quot;Grp1quot; , quot;Grp2quot; , quot;Grp3quot;). 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 quot;Grp1quot;
was choosen person A, B, and C gets and email notifying them that they need
to do something. When quot;Grp2quot; 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
--
Melaniequot;Melaniequot; wrote:

gt; I have an excel spreadsheet with five columns. On column D I have a drop
gt; down list with four choices (quot;n/aquot; , quot;Grp1quot; , quot;Grp2quot; , quot;Grp3quot;). When a row
gt; is filled in, one of the four choices in column D has to be choosen. When
gt; the user exits the spreadsheet an email is automatically sent to three
gt; different individuals based on what was choosen in column D. I.E. If quot;Grp1quot;
gt; was choosen person A, B, and C gets and email notifying them that they need
gt; to do something. When quot;Grp2quot; is choosen then person D, E, F are notified.
gt; And so on.
gt;
gt; Does anyone know how I can do this? Help help help!
gt;
gt; Melanie