Send email based on pop up menu selection?
I'm using a spreadsheet as a project management system of sorts. Is it possible, based on a cell selection, to send an email to that person with other information from cells as a formatted work order of sorts automatically?
i.e.
if the column is "Responsibility" and I select "James" from a pop up menu can it pull the information from other cells in that row and send a formatted email, or even just a standard email alerting "James" to his need to check the shared sheet?
Macbook Pro, Mac OS X (10.6.6)