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

请先登录再写评论。