Print a report to a specific printer but not the default

[Saa62]

2 questions:

1: I have a database that different people will use to create a one page report.(A shipping request) The one page report then needs to be sent to a specific printer on the network,(the clerks desk) and also print a copy of the report to users network printer.(So a copy of the shipping request can be attached to the shipped parts) Is this possible?

2: If the above is possible, then is it possibe to have a pop up window to ask how many copies to print on the users printer.

Thanks

I have question 1 figured out. I created a copy of the same report and did individual page set up for the printers. I would still like to be to choose how many copies to print on one of the printers with a pop up window.

 

[tails]

Well first make a macro to print out a copy to the users printer and the clerks printer. then once thats created just make a do loop to continually print reports to both printers. now make 2 variables, it doesn't matter what they are but single letters work better
i normally make an 'a' and a 'b' variable, but you can use whatever two letters you like.
firstly at the start of the code do
b = 0
a = inputbox("How many copies do you need")
then have the do
there will be all the macro code in here for the print function
in there put b = b + 1
at the end of the code just before the end sub put loop until b = a
it will print the copies inputted into the inputbox (textbox) when you call the macro.