SeniorNewbie
Board Regular
- Joined
- Jul 9, 2023
- Messages
- 71
- Office Version
- 2021
- 2019
- Platform
- Windows
- MacOS
Hi out there!
I'm currently playing around with some workflow optimizations with printers. So far I have found a solution to assign each XL sheet to its own printer: Invoices are sent to a laser printer, images to an inkjet, bcc documents to a pinwriter.
Now I want to create sets of hardcopy commands to avoid that each sheet needs its own print command. To do this, it is necessary to mark either the printer or the sheet as an element of the set.
As an example: It is a simple sale, so I need an invoice (laser) and a bcc document (pin) for a delivery bill.
Sorry for the very old school examples.
As markers I don't want to use CustomDocumentProps or hidden sheets. My idea so far is to write the marked sheets or printers to an external .txt-file - unfortunalty vulnerable by users ...
Anybody out there with a smarter idea as CustomPrinterProp?
THX a lot in advance
and enjoy the weekend
Senior Newbie
I'm currently playing around with some workflow optimizations with printers. So far I have found a solution to assign each XL sheet to its own printer: Invoices are sent to a laser printer, images to an inkjet, bcc documents to a pinwriter.
Now I want to create sets of hardcopy commands to avoid that each sheet needs its own print command. To do this, it is necessary to mark either the printer or the sheet as an element of the set.
As an example: It is a simple sale, so I need an invoice (laser) and a bcc document (pin) for a delivery bill.
Sorry for the very old school examples.
As markers I don't want to use CustomDocumentProps or hidden sheets. My idea so far is to write the marked sheets or printers to an external .txt-file - unfortunalty vulnerable by users ...
Anybody out there with a smarter idea as CustomPrinterProp?
THX a lot in advance
and enjoy the weekend
Senior Newbie