You can create a macro to issue an email. See:

http://www.rondebruin.nl/sendmail.htm
--
Gary''s Student - gsnu200777


"chitrakala" wrote:

Having the drop down option include "Completed", "In Progress",etc... in one
column of the sheet name called "Task Sheet". i want to raise and send alert
to the respective person who are not completed the task.

How can i achieve this using Excel?

thks

chitra