Printing labels with different amount of copies from database Folgen

0
Avatar
James Mitchell

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

2 Kommentare

0
Avatar
Peter Thane
Aktionen für Kommentare Permalink

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
Avatar
James Mitchell
Aktionen für Kommentare Permalink

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

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