Date:07/23/2007 ID:faqp001040_000




Title:

How to use Excel data to print labels

Description:
Please follow the instructions below.
  1. Preparing the database.

    Image

    Using file "parts.xls" in the program folder at Program Files\Brother\Ptedit42\Samples.

    Image



  2. Connecting the database

    • Click [File]–[Database]–[Connect...].
    • Select the prepared Microsoft Excel file. ("Parts.xls" in the folder "Program Files\Brother\Ptedit42\Samples")
    • Select the "Header Row Contains Field Names" check box in the Open Database dialog box.
    • Click the Open button.

      Image

    • The Select Database Editing Mode dialog box appears. e.g select "Connect as read-only", and then click the "OK" button.
    • The database appears.

      Image

    3. Note

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

  3. Merging data into a layout as text

    First, 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.

    Merge the database data into the layout.
    • Click the field name "Part Name".

      Image

    • Drag the field name into the layout window. In the pop up windows that appear, select "Text".

      Image

    • In the same way, merge the field name "Model Name".

    4. Note

      The field names can also be merged using menu commands. Select the fields in the Merge Fields dialog box, which appears after clicking [Database Field...] on the [Insert] menu or clicking [Merge into Layout...] on the [Database] menu.
  4. Merging data into the layout as a  bar code

    • Click the field name "Part Code".

      Image

    • Drag the field name into the layout window. In the dialog box that appeared, select "Bar Code".

      Image

    • Adjust the bar code data. To adjust height, width and alignment, drag a corner handle of the merged bar code data, and then reduce the height of the bar code.

      Image

    • Double-click the merged bar code data.
    • Click the [Setup] tab of the Bar Code Properties dialog box.
    • To adjust width, under "Width", select "Small".
    • To adjust alignment, under "Show Characters", select "Center".
    • After specifying the desired settings, click the "OK" button.

      Image

      Image

    5. Note

      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.
      • Data that cannot be used with that 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.
  5. Aligning the objects

    • Click Image to display the Layout Properties.
      (If the button already appears selected, this step is not necessary.)

    Align all objects along their horizontal centers.
    • Drag each object to determine their general positions.
    • Click [Select All] on the [Edit] menu to select all of the objects.
    • Click Imageon the Layout Properties.

      Image

      Image

    • Align all objects vertically along the width of the label.
    • Click Imageon the Layout Properties.

      Image

      Image


  6. Printing

    • Click Image to display the Print Properties.
      (If the button already appears selected, this step is not necessary.)
    • Click Image  on the Print Properties.

      Image
      The name of the printer being used appears for "Printer Name".
    • Under "Print Range", select "All Records".
    • After specifying the desired settings, click Image to begin printing.

      Image

    7. Note

      For details on selecting a record range, refer to the following table.

      Print Range

      Records to be Printed

      All Records

      Print all records.

      Current Record

      Print the current record.

      Marked Record(s)

      Print only the marked records.

      Record Range

      Print records in the range specified by "From"   and "To".
If your question was not answered, please check...
  

  • Have you checked other FAQ's?

  • Is the answer in the user guide?

  • If you need further assistance, please contact Brother customer service:

Related Models

PT-1500PC, PT-1650, PT-18R, PT-1950, PT-2100, PT-2300, PT-2600, PT-2700, PT-3600, PT-9200DX, PT-9200PC, PT-9500PC, PT-9600, QL-1050/1050N, QL-500, QL-550, QL-650TD

Was the information on this page helpful?

Please indicate (above) if the information was helpful or not. If you have additional comments please enter them into the area below and click Submit.

Sorry, we cannot reply directly to your e-mail, but we will listen to your comments.

>Clear