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