Save Workshetts as Separate Files
 

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?

Save Workshetts as Separate Files
 

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?

Save Workshetts as Separate Files
 

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?