the one we have is

=IF(G6="EMAIL",HYPERLINK("mailto:"&D7&"?subject="& D6&" has completed
"&D2&"&body="&D2&" is waiting for your approval. %0d%0a %0d%0aThanks,
"&D6&"%0d%0a%0d%0a%0d%0a","Email"),"")

so if G6 is not "EMAIL" , selecting the cell will not EMAIL but if it is ,
then the hyperlink should work.

"sycsummit" wrote:

I want to add an "submit" button on a worksheet that will email the whole
workbook to a single address with one click (or perhaps trigger a user
confirmation popup, to verify submission). I've been to
http://www.rondebruin.nl/sendmail.htm
and read through several threads but I can't figure out how to add a
clickable button and apply the code to it... or which code to apply... any
suggestions?