Have a look at how Ron de Bruin does it.

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

Note: Ron's SendMail add-in is very handy to have.


Gord Dibben MS Excel MVP

On Thu, 27 Sep 2007 11:17:03 -0700, summerelli
wrote:

How do I assign a command for the following spreadsheet? Once the information
has been completed, I would like the user to click a button and have the
spreadsheet sent (automatically) to me.