Print from Excel database to a specific order on template. 追蹤

0
Avatar
David Woerner

I am looking for a way to print from Excel database onto my 3 label wide stock in a specific order.

 

I would like Column A to print vertically on the left line of label, Column B to print down the middle labels and Column C to print Down the right line of labels.

 

Is there a way to do this?

5 意見

1
Avatar
adam cummick
評論操作 永久連結

I would create three different label templates, each with the proper information on them. Then in the page setup options you can confirm they are arranged how you want.

 

0
Avatar
David Woerner
評論操作 永久連結

How would I print it at the same time?  The stock is 1 page, 3 labels wide.

1
Avatar
Bob Steele
版主
評論操作 永久連結

Hello David,

Adam has the right idea, you would create a label with 3 templates, one for column 1, one for column 2, One for column 3.  You can find more information on using templates in Bartender here https://support.seagullscientific.com/hc/en-us/articles/205643307-Templates-in-BarTender-Video-7-30-

Thanks!

0
Avatar
David Woerner
評論操作 永久連結

THIS IS GREAT, THANK YOU ! Worked easily and did exactly what I needed.  

0
Avatar
Bob Steele
版主
評論操作 永久連結

David,

You would set the templates to print one after the other in the page setup of the label, then when you print the first template would print to label 1, 2nd to label 2, etc.

 

Thanks

登入寫評論。