Hello,

In my spreadsheet, I want that, as soon in one specific cell the value turns false, an automatic e-mail should be sent to a specific e-mail address, the address is in other cell, one of the problems is there are 6 users for the same email, and I want to put in the subject line her or his Name, the name is in other cell all in the same sheet looked up from other sheet.

The message corp on the e-mail should be the same, but with a different hyperlink with the issue N?. all that information are in the same sheet. and finally after the e-mail was sent another cell should be ticked telling that the email was sent. probably after put the mechanical thing working it is easy to deal with the last one.

Hope this make sense, I always have difficulties to post in this forums " specially the titles ", my native language is not English, but any way, any help is welcome and very much appreciated.

Jo