Add button in worksheet to send email

[iseekxlhelp]

Does anyone know how to create a button in a worksheet
that, upon clicking it, will automatically attach the
file to an email to a specified recipient? Thanks.

 

[Paul B]

Have a look here for some send mail code,
http://www.rondebruin.nl/sendmail.htm#Workbook.

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Ron de Bruin]

Hi iseekxlhelp

Check out my SendMail page
http://www.rondebruin.nl/sendmail.htm