I have 3 weekly reports that must be sent to 3 different goups. I have each
as a separate Excel template. To fill them out, I have to open 3 instances of
Excel. I want to combine them into one Workbook w/ 3 Worksheets. How can I
save each worksheet as a separate file for the purpose of sending the reports
to the right goups?

Hi Elvis

You can use a macro to mail every sheet to the correct group.

See example 2 on this page
http://www.rondebruin.nl/mail/folder1/mail2.htm

Or add a sheet template to the workbook if you not like code
http://www.rondebruin.nl/mail/templates.htm





--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Elvis" wrote in message ...
I have 3 weekly reports that must be sent to 3 different goups. I have each
as a separate Excel template. To fill them out, I have to open 3 instances of
Excel. I want to combine them into one Workbook w/ 3 Worksheets. How can I
save each worksheet as a separate file for the purpose of sending the reports
to the right goups?

Hi Elvis

Right click on sheet TabMove or CopySelect Copyuse dropdown on ToNew
Workbook

--
Regards
Roger Govier

"Elvis" wrote in message
...
I have 3 weekly reports that must be sent to 3 different goups. I have
each
as a separate Excel template. To fill them out, I have to open 3 instances
of
Excel. I want to combine them into one Workbook w/ 3 Worksheets. How can I
save each worksheet as a separate file for the purpose of sending the
reports
to the right goups?