How to print from a database

BarTender

1. Double click on either a text box or barcode to open the textbox or barcode properties dialog box.
2. Click on the icon to the right of the box Type in the Data Source tab, which by default reads Embedded Data.
3. Select Database Field from the dropdown menu and click Finish.
4. Click Database Connection Setup and select your Database Type, e.g. Excel.
5. Click Select File and browse to the location where your database is stored. Select the file you would like to retrieve your data from and click Open. Click Next, then Finish. Click OK.
6. Click on the arrow next to Field Name to select the column in your Excel file you would like to associate with your textbox or barcode, then click close.
7. To connect the same database to a different textbox or barcode, double click on the textbox/ barcode, then on the symbol next to the Type field and select Database field. Click Next.
8. Select the column you’d like to connect to the textbox/ barcode from Field Name drop down menu and click Finish, then Close.
9. Click Print to open the Print dialog box. Selected Records lets you choose how many database entries you’d like to print.
   
   
   
   
10. Leave the value at 1…. if you’d like to print all entries of your database. To print e.g. only the first 50 entries of your database, type 1-50.
    
    
    
    
11. You can select how many copies per database entry will be printed by changing the value in Copies per Serial Number accordingly.
12. Click on Preview to verify that the correct records as well as the correct amount of copies per record will be printing before starting the print job.