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
> i would like to insert a button to automatically email a spreadsheet to a > certain person