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

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


--
hays4
------------------------------------------------------------------------
hays4's Profile: http://www.excelforum.com/member.php...o&userid=28069
View this thread: http://www.excelforum.com/showthread...hreadid=482170

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

"hays4" wrote in message
...

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

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


--
hays4
------------------------------------------------------------------------
hays4's Profile:
http://www.excelforum.com/member.php...o&userid=28069
View this thread: http://www.excelforum.com/showthread...hreadid=482170

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

--
Regards,
Tom Ogilvy


"Barb Reinhardt" wrote in message
...
This is probably a better question for microsoft.public.excel.programming.

"hays4" wrote in
message
...

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

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


--
hays4
------------------------------------------------------------------------
hays4's Profile:
http://www.excelforum.com/member.php...o&userid=28069
View this thread:
http://www.excelforum.com/showthread...hreadid=482170