Printing Multiple Labels Follow

0
Avatar
Legacy Poster

Hi

 

Firstly, apologies for what I know is going to be a very simple/daft question and I'm also not too certain that I've chosen the correct forum subject either! :/

 

I have a requirement to print SKU labels. What I would like to do is link the label template to an excel spreadsheet. The spreadsheet will contain the SKU, the Description and in the final column the number of labels that I would like to print of that particular SKU.

 

So - my question are:-

 

  1. This only needs to be set up on one PC and printer; what version of Bartender would I need to achieve this?
  2. I believe that I'd be fine linking the template to an excel spreadsheet using ODBC?, but how would I best achieve printing multiples using the valuable value inputted into the third column of the spreadsheet?

Thanks for reading and any help greatly appreciated...

 

B

 

2 comments

0
Avatar
Legacy Poster
Comment actions Permalink

Hi Brett,

1. For one PC and printer then it sounds like the Professional version will do the job.

2. Once you have linked the label to the Spreadsheet, on the Print screen there is a button to the right of the number of labels box and if you select this you can then change the field to "Get quantity from database field" and use the dropdown to choose the correct field in the spreadsheet.

I hope this helps

Pete

0
Avatar
Legacy Poster
Comment actions Permalink

Cheers Pete - Much appreciated..

 

B

Please sign in to leave a comment.