Take a look at www.rondebruin.nl/sendmail.htm

--

HTH

RP

"matpj" wrote in
message ...

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