Hi folks,
Have not posted in a long time but I ran into a problem that I do not know the best way to approach for a solution.
We have to ship 25 books per carton to over 2,000 stores. The number of books per store is different and is in the second column. If a store get 30 books, then we need 2 cartons.
I need to print labels for the cartons. If there are 2 cartons, then I need 2 labels: Carton 1 of 2, Carton 2 of 2.
I'm guessing Word and Mail merge is where I would print the labels, but I haven't a clue how to drive the data so that I can create the labels.
Any suggestion on which way to attack this would be greatly appreciated at this time.
Much thanks for your valuable time with this,
Ed Wong
Bookmarks