Printing Container Numbers

Legacy Poster

• February 29, 2016 19:44

Hello, 

 

I have a spreadsheet that I am trying to link as a database to a label template. It is in the following format:

 

[Name] [Part#] [#ofcontainters]

Dog       ABC     2

Cat        DEF     3

 

If a given line lists X number of containers, I want to print that row X times and place a counter for the # out of X that printer

 

For example, the above sheet would be expanded to

 

[Name] [Part#] [#ofcontainters]

Dog       ABC     2

Dog       ABC     2

Cat        DEF     3

Cat        DEF     3

Cat        DEF     3 

 

and the labels printed would be:

 

Dog       ABC     1 of 2

Dog       ABC     2 of 2

Cat        DEF     1 of 3

Cat        DEF     2 of 3

Cat        DEF     3 of 3

 

Thanks for your help! 

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • March 19, 2016 13:02

  You need to data source the quantity to print for each record from the database field.  On the label you can have a serial number that resets to 1 for each record, and combine it with the quantity field for the X of Y text.

  0

Please sign in to leave a comment.