Email To button in excel
 

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?

Email To button in excel
 

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?

Email To button in excel
 

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?