Brother QL-500, QL-550, QL-650TD 1, 2, 3, 4

Creating Labels Efficiently

IntroductionCreating Labels (For Windows)Creating Labels (For Macintosh)Appendix

Using external database files

This section describes the procedure for creating barcode labels with a database.

The following example uses a Microsoft® Excel file as a database.

1Prepare a database file.

The following example uses a file (.xls) created

with Microsoft® Excel, as shown right.

2Start the P-touch Editor and specify the

label size.

In this example, specify [1-1/7"x3-1/2"] for the

Tape Width box in the Page properties.

3Click [File]-[Database]-[Connect].

The [Open Database] dialog box appears.

4Select the Microsoft® Excel file you have

prepared and click .

The [Select Database Editing Mode] dialog box

appears.

The supported database file formats are: mdb (Microsoft® Access®), xls (Microsoft® Excel), csv, and txt.

If the file you use has multiple sheets, the

[Table Selection] dialog box appears.

Select the sheet you want to use.

Contents

Main Contents BROTHER QL-500/550/650TD Software User's Guide Introduction About This Manual Manual Structure Setup & Operation Guide Software User's Guide (this manual) Creating Labels (For Windows) Label Creation Overview 3 Printing directly Printing using the PC Starting P-touch Editor 1 [Brother P-touch]-[P-touch Editor 4.2]. How to Use P-touch Editor Layout window Creating an Address Label 1 2 3 Printing a Label 1 be printed to [1] and click . 2 button (Brother QL-550/650TD) or the Cut lever (Brother QL-500) of the printer. Page Creating Different Types of Labels Using the P-touch Editor Help Opening the Help files 1 2 P-touch Editor Help window Page Creating Labels Efficiently Using the Label List Opening the Label List 1 Switching the Label List view Page Layout Styles 2 3 Page Page Page Printing labels from the Label List 1 2 3 Using external database files 1 2 3 4 5 6 7 8 9 Page Creating Labels with Other Applications Add-In settings 2 [Brother P-touch]-[P-touch Tools]- [P-touch Editor 4.2 Add-Ins Utility]. Microsoft Word 1 select the text you want to print. 2 Toolbar in the Add-In Preview window How to add the Microsoft Word text to a label list Microsoft Excel Creating labels using Microsoft Excel 1 2 3 How to add the Microsoft Excel text to a label list Microsoft Outlook Creating labels using the Contacts data in Microsoft Outlook 1 and select the Contact information you want to include. 2 How to add the Microsoft Outlook text to a label list When importing data from the Contacts window: When importing other than Contact information: Starting the P-touch Address Book 2 How to Use the P-touch Address Book Layout window Creating a New Contact 1 2 New Contact form toolbar Contact form Importing the Contact Data Importing the contact data in CSV format 1 2 3 Page Printing the Label 1 2 button (Brother QL-550/650TD) or the Cut lever (Brother QL-500) of the printer. Print Options and label cutting How to Use the P-touch Transfer Manager (Brother QL-650TD Only) For the Brother QL-650TD only 4 5 6 LCD display on the Brother QL-650TD Transferring a Message 2 3 5 6 Backing Up the Data in the Main Unit 2 3 How to Use the P-touch Backup Manager (Brother QL-650TD Only) For the Brother QL-650TD Page Creating Labels (For Macintosh) Overview 3 Using the P-touch Editor Layout Window Draw Toolbar Print Toolbar Database Toolbar Layout Window Property Dock Page Printing the Label 1 2 3 Printing Options Tape Settings Halftone/Color P-touch Editor Page Users Guide (HTML Manual) Window Appendix Using this printer as a Shared Printer Using the PS-9000 Print Server (sold separately) Sharing the printer Available Commands Controlling with the ESC/P Commands Descriptions in this section apply only to the functions provided by the Brother QL-650TD. Brother QL-650TD Only Installing the Printer Driver 1 2 click [File]-[Printing Preferences]. Printing Directly from Other Applications 4 Page Uninstalling the Software Page Page 1 2 3 4 5 Using with Mac OS X Classic (Mac OS 8.6 ~ 9.2) Page 12 13 14 15 16 17 Page Product Specifications Operating Environment Specifications