Automated emails from excel??

[Jay3]

Hi Everyone,

I have a task list in excel on a shared spreadsheet, when someone adds a new task for me to complete I would like an automated email to be sent from them tome or vice versa.

Can this be done...we use outlook 2007.

The from and to email addresses could be picked up from certain cells within the spreadsheet and I would want the body of the email to be th query they have recorded on the spreadsheet in cell G1 for example?

I thought one the add a new query the next column in teh spreadsheet could be a "notify" column and wen the user selects YES from a drop down list the email is generated.

Any ideas?

Thanks
Jay3

 

[VoG]

This may help http://www.rondebruin.nl/mail/change.htm

 

[Jay3]

Thank you this is really helpful!