Check out Ron de Bruin's site for example code and workbooks.

http://www.rondebruin.nl/sendmail.htm

Also his SendMail add-in is quite handy for the task described.


Gord Dibben MS Excel MVP

On Wed, 3 Jan 2007 15:49:01 -0800, max power
wrote:

i need to create a button on an excel work sheet that when pressed will email
the sheet as an attachement to various email adresses.

any suggestions on how the macro should look would be greatly apprecieted