John, have a look at Ron's site here for ways to do it

http://www.rondebruin.nl/sendmail.htm#Tips
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"John" wrote in message
...
I have a little problem. I have created a form that is too large to send
to
my department. The only portion of the form that i need is what really
needs
to be emailed. Someone once suggested using SendMail, but i can not
figure
that out.

1. Can you send a single worksheet within a workbook without using
SendMail.

if not

2. I have figured out how to copy a worksheet into a new workbook, but how
do you include that as well as a save promt that will allow users to
select
the name they want to save it as?

I hope this makes sense. Thank you for any help that you can be