I have a little utility that prints Pallet Labels. It uses an Excel template which it populates dynamically and then prints using automation. This works fine at present even if there is several labels per order as each page is sent to Excel and printed directly to a printer.
The problem I am having is that it now needs to print the labels to PDF. But of course each label is currently being produced via Excel individually. Can someone suggest how I can make it print each page to a single PDF file?