Remainder pallet labels
Hello,
I have to print 4 labels per pallet we ship. The number of pallet labels is directly influenced by the amount of product shipped. Usually this number isn't an even divisible number by the amount of space (30) on the pallet. So, we end up with:
(scenerio with 40 items. 30 per pallet can fit)
Pallet 1 of 2
30 Items
Pallet 2 of 2 (usually manually typed in by me)
10 Items.
I have everything linked to excel to make things easier, but I'm having a really tough time figuring out how I automate the last remaining pallet. I'm assuming this can be done in VB script, but I could be wrong. Thanks!
Justin
-
I think we need more information on what you're trying to do and what you've already solved through the Excel file. I assume the Excel file contains info about the items but what you want to automate is the number of labels printed and the quantity per label?
In general, you can assign a data source name to the "copies" input field of the print dialog. Now you could e.g. have user input, manipulate that input and pass the result to that data source. You can also manipulate per-label-data using the "OnIdenticalCopies" event. So I think it's definitely possible but I don't know how much of that solution you need or how it should look like to work for your scenario.
0
Please sign in to leave a comment.
Comments
1 comment