Follow the instructions below:

1. Preparing the database

    

   Use the file "Parts.xls" in the folder at Program Files "C:\Program Files\Brother\Ptedit5x\Samples" or "C:\Program Files (x86)\Brother\Ptedit5x\Samples.
   

    

2. Specifying the size of the label
   
   In the Paper palette, specify the tape length and width desired.
   
    
3. Connecting the database

    

   1. Click [File] - [Database] - [Connect...].
      
      <Using Professional mode as an example. You can edit on Express mode as well>
      
       
   2. Select the prepared Excel file. Check [Header Row Contains Field Names] and [Connect as read-only], and then click the [Next] button.
      
       
   3. The database appears.
      

      If the file being used contains multiple sheets, the Select Database Table dialog box appears. Select the sheet that you want to use.

    

4. Merging data into a layout as text
    
   1. Specify the font that will be used in the layout.
      • In the Font box on the Text Properties, specify the font, e.g. "Arial".
      • In the Font Size edit box on the Text Properties, specify the font size, e.g. "14".
      • The font and size can also be changed after text is pasted into the layout.
   2. Click the field name "Part Name" and drag the field name into the layout window. The dialog box appears. Select "Text".
      
      
       
   3. In the same way, merge the field name "Model Name".
      


5. Merging data into the layout as a bar code

    

   1. Click the field name "Part Code" and drag it into the layout window. The dialog box appears. Select "Bar Code".
      
      
       
   2. Double-click the merged bar code data.
       
   3. Click the [Setup] tab in the Bar Code Properties dialog box. To adjust width, select "Small" for "Width". To adjust alignment, select "Center" for "Show Characters". After specifying the desired settings, click the [OK] button.
      

      Depending on the selected barcode protocol, the data may not be displayed.
      ("Invalid" or "Incorrect check digit" appears.)
      If the barcode cannot be displayed, any of the following may be the cause:

      • The data that cannot be used with the barcode is included.
      • The data does not include the specified number of digits.
      • The check digit calculation is incorrect.

      Check the data or change the barcode protocol. e.g. "CODE39" or "CODE128" can be used.


6. Aligning the objects

    

   1. Click [Edit] - [Select All] to select all of the objects.
      
   
   
   2. In the Layout palette, click the "Align Horizontal Center" button. All objects will be aligned along their horizontal centers.
      
       
   3. You can also align all objects vertically along the label width with the "Align Vertically Center" button.
      
      

    

7. Transferring label templates to a printer
   
   Refer to the following FAQ to transfer label templates to a printer.
   "How do I transfer templates or other data from the computer to the printer?"


8. Printing

   When transfer is completed, press to exit Transfer mode and disconnect the USB cable from the printer.

    

   1. Press , then the PF key where the template that you wish to use is assigned.
   2. Press . The database data is displayed.
       
   To select a single database record to be printed in the template:

    

   3. Press or to highlight the desired record, and then press .
   4. To edit any text in the record, press or to display the text, and then type in the new text.
   5. Press .
       
   To select a range of database records to be printed in the template:

    

   3. Press or to highlight a record, and then press .
   4. Press , then . The message "CLEAR TEXT & PRINT DATABASE?" appears.
   5. Press .
   6. Press or until RECORD NO. is displayed, and then specify the desired range of records.
   7. Press (or ). CONFIRM appears in the Print Option menu.
   8. Press (or ) to begin printing the labels using the specified range of records.