hi,
see this site
http://www.rondebruin.nl/sendmail.htm
it contains all the code you need to do this. after that you just need to
attached the macro(s) to a sheet command button or toolbar icon button.(you
didn't say which)

Regards
FSt1

"George" wrote:

i would like to insert a button to automatically email a spreadsheet to a
certain person