create a send button in excel
 

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

create a send button in excel
 

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

create a send button in excel
 

Do you want a new macro for each group of addresses or a macro that sends
mulitple emails to each different group.


Christina

"max power" wrote in message
...
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