-
Printing single job to multiple local printers at same time
I have several documents that I print one color copy (logo in color), on a HP OfficeJet 6110 All-in-One, to send to member and then another copy using my HP LasterJet 6/6MP for a black & white copy that is for my records. Is it possible to create a button that will do this automatically with one click?
-
Try this:
[VBA]
ActivePrinter = "MyPrinter1"
ActiveDocument.PrintOut
ActivePrinter = "MyPrinter2"
ActiveDocument.PrintOut
[/VBA]
Record a macro and print to each of your printers to get the actual name.
-
Hi Jatherton,
I posted a KB entry here
http://www.vbaexpress.com/kb/getarti...851c3e209acfae
which allows for easy selection of printers. By changing the option boxes to check boxes, a multiple print option could readikly be created.
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules