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?

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?

Would this automatically email the file though? Or just open up the default
email program? I want to avoid the extra steps of having to open up a new
program, type in the address, and attach saved file. One step would be much
more efficient.

"Don" wrote:

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?