Printing labels with different amount of copies from database

James Mitchell

• 15. August 2019 09:39

Hi all,

Bullet points may be the best way:

• There's two labels (.btw files) - Say label A and B 
• I have one database (an Excel file)
•  There are 4 columns
•  For each record, I need...
•  The first two columns to print twice
•  The second two columns to print once
•  The order of the labels to print out like A A B A A B A A B... etc.

How do I achieve this? I've seen this thread but the user didn't make it terribly clear on how they achieved it. If I need to do some VBA that's fine I just need to know how (not exactly an experienced programmer!)

Thanks

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 17. August 2019 09:42

  If the labels are the same size and printed on the same printer then the simplest way to do this would be to make one label but made up of 3 Templates. Template 1 and 2 would be identical (ie both Label A) whilst the 3rd template would be configured like your other label layout (Label B in your example).

  With this whenever you select a record and print it you will get the 3 labels you require in A>A>B sequence and if you print multiple copies then sequence will repeat. 

  If Label A and Label B are different in size or needs to be printed by a different then you will need to use Integration Builder and log the output of Label A and use that to trigger the production of Label B

   

  0
• 

  James Mitchell

  ★ BarTender Hero ★

  • 22. August 2019 22:40

  Cheers for the advice, worked like a charm! Janky but whatever I'm happy.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.