automate printing

[mshobe]

We have an excell file that has different sheets that need to be emaile
to different departements within our organization. We are trying t
automate the system so that it will print the sheets that go to eac
department automatically.

Example: 1 sheet to dept a
the next sheet will go to dept b

we tried using print to file but it does not give us a usable file tha
can be emailed. Can someone help us with this

 

[Trevor Shuttleworth]

Look at Ron de Bruin's web site for different approaches to emailing
workbooks, worksheets and so on.

http://www.rondebruin.nl/

Regards

Trevor