Separate the printing based on a column value?

Michael

• August 07, 2017 15:56

Is it possible in Bartender (10.1 SR2) to select all records (from an Excel file) during print time, however have the program use the values in a column to separate the print job? E.g. A table with the following in column A:

• X00011
• X00011
• X00012
• X00013
• X00013
• X00013
• H00011
• H00015
• H00015

etc., I'd like to print all records for X00011 in one batch, then move on to all X00012, X00013 and so on.

My issue with simply selecting all records and printing is that when one set finishes, it prints the next set without leaving any gaps and prints on the same sheet. I'd like to use page template design to have the above value(s) as a heading to easily separate the label pages. 

0

• Official comment

  

  Gene Henson

  Official comment

  ★ BarTender Hero ★

  • August 07, 2017 22:42

  I think you may find this video helpful: https://support.seagullscientific.com/hc/en-us/articles/227837107-Inserting-separator-labels-Video-1-49-

  That will show you how to treat the values in that column of your spreadsheet as a group and print a separator label each time the value changes. The "separator label" can have a completely different design, which makes it easy to distinguish from the regular labels.

  Hope that helps. Let us know if it doesn't work for you.
• 

  Michael

  ★ BarTender Hero ★

  • August 08, 2017 08:20

  Thanks for the help, it was definitely useful.

  As an addition, instead of printing a separator label between each group, is there any way to treat each of these groups as their individual own print job? I'd like to create a page template and use the value in the above column as the header on the page to easily distinguish a new group, which would be difficult if the sheet had multiple different values from that column.

  0

Please sign in to leave a comment.