HI,
I have a work logging spreadsheet that allows me to keep track of
outstanding items.
The assignee of the tasks are chosen using a static drop down list
(data validation)

I'm hoping for an automated email to be sent to the persion I assign a
task to, containing the contents of several cells (and a standard
subject line)
Is this possible?

can anyone give me any tips/advice/code?

thanks in advance,
Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=501974