This could be done via API but from your other questions I am guessing you are not a programmer. Google has a great new addition to Spreadsheets called Scripts. It will do what you are asking.
For sending the email for change in a cell look at: http://www.google.com/google-d-s/scripts/scripts.html There is a video here: http://www.youtube.com/watch?v=7ux-IexZFec&eurl=http%3A%2F%2Fgoogleappsscript.blogspot.com%2F&feature=player_embedded That shows exactly what you want to do. On Fri, Sep 11, 2009 at 12:09 PM, thstart <thst...@gmail.com> wrote: > > How to do the following: > > send email notification to hard coded email address when > a cell in a cell range is equal to predetermined value - a string > value? > I want the email to contain this string value in the subject and > the body. > > > -- James Ferreira Chief Information Officer Office of the New Mexico Attorney General 505.231.2487 jferre...@nmag.gov --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" group. To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com To unsubscribe from this group, send email to google-docs-data-apis+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---