Button to email my spreadsheet

[hays4]

I have created a form on a spreadsheet and I want the user to fill it i
and then click a button that will email the form to a regular emai
address.

So do I create a macro behind a button, that emails a spreadsheet to a
address?
And how? :

 

[Barb Reinhardt]

This is probably a better question for microsoft.public.excel.programming.

 

[Tom Ogilvy]

See sample code at Ron de Bruin's site:
http://www.rondebruin.nl/sendmail.htm