Answer to your Frequently Asked Question:

Printer Friendly
Description of Problem 100000032816

How to print labels from Excel data with a barcode?

Description of Solution 200000042072


Please follow the instructions below:

Preparing the database

Using the file parts.xls, this is in the folder at: Program Files\Brother\Ptedit50\Samples.

Specifying the size of the label

1.    Click    to display the Paper Properties.

Note: If the properties are currently displayed, this step is not necessary.

2.    E.g. Specify 1-1/7 inch (29 mm) in the Tape Combo box, and 3.2 inch (81.3 mm) in the length edit box.


Connecting the database

1.    Click File => Database => Connect

2.    Using Professional mode as an example; you can edit in Express mode as well



4.    Select the prepared Microsoft Excel file.

5.    Check the Header Row Contains Field Names check box.

6.    Check the Connect as read-only box and then click the Next button.

The database appears.



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

Merging data into a layout as text

1.    First, specify the font that will be used in the layout.


2.    In the Font box on the Text Properties, specify the font, e.g. Arial.


3.    In the Font Size edit box on the Text Properties, specify the font size, e.g. 14.


4.    The font and size can also be changed after text is pasted into the layout.




Merge the database data into the layout.


1.    Click the field name Part Name and drag the field name into the layout window. 


2.    The dialog box appears. Select Text.






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


Merging data into the layout as a bar code

1.    Click the field name Part Code and drag it into the layout window.

2.    The dialog box appears.

3.    Select Bar Code.



4.    Double-click the merged bar code data.

5.    Click the Setup tab of the Bar Code Properties dialog box.


6.    To adjust width, under Width, select Small.


7.    To adjust alignment, under Show Characters, select Center.


8.    After specifying the desired settings, click the OK button.


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

1.    The data that cannot be used with the barcode is included.


2.    The data does not include the specified number of digits.


3.    The check digit calculation is incorrect.

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

Aligning the objects

1.    Click   to display the Layout Properties.

Note: If the properties are currently displayed, this step is not necessary.

2.    Align all objects along their horizontal centers.


3.    Click Select All on the Edit menu to select all of the objects.

4.    Click the Align Horizontal Center button.


5.    You can also align all objects vertically along the width of the label with the Align Vertically Center button.




Click    to display the Print Properties.

Note: If the properties are currently displayed, this step is not necessary.

Click on the print property pallet.


The Print dialog box will appear. Under Print Range, select All Records.

After specifying the desired settings, click the Print button.


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 Records

 Print only the marked records.

Record Range

 Print records in the range specified by From and To.


Was this helpful?
Please help us to improve our services by letting us know if this information was helpful: