MS Excell Macros; search document and print
Posted on 2011-10-19
I need to create a macros in excel that will search for a set of documents on various network shares and print those documents. Currently, I'm having to navigate to each document, open and print several copies of each. I then make job packages by putting a copy of each into different stacks. I have to create dozens of job packages per day. This is very time consuming. I would like to click one button that will find and print all the document required for a job package, go to the printer and retrieve the entire bundle of documents for one job package. Click the button again for the next and so on. Is this possible?