Brother QL-500, QL-550, QL-650TD appendix Using external database files, Prepare a database file

Page 21

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.

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

1 Prepare a database file.

The following example uses a file (.xls) created with Microsoft® Excel, as shown right.

Introduction

2 Start 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.

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

The [Open Database] dialog box appears.

4 Select the Microsoft® Excel file you have

prepared and click .

The [Select Database Editing Mode] dialog box appears.

If the file you use has multiple sheets, the [Table Selection] dialog box appears. Select the sheet you want to use.

21

Creating Labels Efficiently

Creating Labels (For Windows)

Creating Labels (For Macintosh)

Appendix

Page 20 Page 22
Image 21
Page 20 Page 22
Contents Software Users Guide Setup & Operation Guide Symbols Used in this ManualAbout This Manual Manual StructureLabel Creation Overview From Label Creation to PrintingChoose the type of label you want to create Create and print a label using P-touch Address Book Create and print a label using P-touch EditorCreate and print the label Use an application from another manufacturerHow to Use P-touch Editor Starting P-touch EditorSelect an option in the Startup dialog box and click Layout window Creating an Address Label Print Options and label cutting Printing a LabelOpening a Label File Saving a LabelClick File-Save As Click File-OpenCreating Different Types of Labels Opening the Help files Using the P-touch Editor HelpTouch Editor Help window Starting P-touch EditorPrinting a Help description Select the range of topics to be printed ClickSpecify the Printer item and click Creating Labels Efficiently Using the Label ListOpening the Label List Click File-Database-Label ListSwitching the Label List view „Record View„Form View Entering data „When is it useful to use a Layout Style? „What is a Layout Style?Layout Styles „Changing the Layout Style for each DK RollReturn to the Layout window to check the labels „Using a Layout Style to create labelsClick File-New „Creating and registering a new Layout Style11Select the layout style you have created Click Click in the Print properties Printing labels from the Label ListChoose the Print Options Print Range, specify the records to be printedPrepare a database file Using external database filesStart the P-touch Editor and specify the label size Click File-Database-ConnectSpecify how the file will be opened, Click 11Click in the Print properties 10Select Bar CodeCreating Labels with Other Applications Add-In settingsMicrosoft Word Creating labels using Microsoft WordOn the Microsoft Word standard toolbar, click Toolbar in the Add-In Preview windowHow to add the Microsoft Word text to a label list Microsoft Excel Creating labels using Microsoft ExcelHow to add the Microsoft Excel text to a label list On the Microsoft Outlook standard toolbar, click Microsoft OutlookHow 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 How to Use the P-touch Address BookText toolbar Menu barLayout style selection view Contact list combo boxClick File-New Contact. Or, click Creating a New ContactEnter data for each item New Contact form toolbarImporting the contact data in CSV format Importing the Contact DataImporting the Outlook contact data Editing the Contact DataClick File-Import-Outlook Contacts Click File-Edit Contact. Or, clickPrinting the Label Creating and Transferring the Download Template Data This is not available for the Brother QL-500/550Click File-Transfer Template D01Address 1-1/7 x 3-1/2 LCD display on the Brother QL-650TDTransferring a Message Creating Labels For Macintosh Appendix Backing Up the Data in the Main Unit How to Use the P-touch Backup Manager Brother QL-650TD OnlyClick the Printer PC tab Select the data you want to back up ClickClick the PC- Printer tab Restoring the backed up data to the Brother QL-650TDProcedure for Creating and Printing Labels OverviewChoose the label you want to create Entering text Î Creating labels Î Starting the P-touch Editor Using the P-touch EditorDouble-click the P-touch Editor 3.2 folder Double-clickPrint Toolbar Layout WindowDatabase Toolbar Layout WindowProperty Dock Select Standard Address Label Click on in the Property dockPrinting Options Click on in the print bar„Copies & Pages „Tape Settings „Halftone/Color„P-touch Editor Installing the Users Guide Html Manual How to use the Users Guide Html ManualOpening the Users Guide Html Manual „Summary„Main Window User’s Guide Html Manual WindowUsing this printer as a Shared Printer Using the PS-9000 Print Server sold separatelySharing the printer Available Commands Controlling with the ESC/P CommandsSerial Cables Brother QL-650TDPrinting Directly from Other Applications Installing the Printer DriverFrom Control Panel, open Printers and Faxes Printers Select each item and clickClose the Printers and Faxes Printers window Printing from Other Applications Click File-PrintSelect Brother QL-500/550/650TD Uninstalling the Software Uninstalling the P-touch EditorFor Windows For Macintosh Uninstalling the Printer DriverCreating Labels For Windows Creating Labels For Macintosh Start up Macintosh, and insert the CD-ROM into CD-ROM drive Click InstallDouble click Driver Installer 15Connect the USB cable to the USB port of Macintosh 18Click OK when the screen shown right is displayed Specifications Product SpecificationsOperating Environment
Related manuals
Manual 128 pages 26.91 Kb Manual 2 pages 29.01 Kb Manual 12 pages 36.27 Kb Manual 6 pages 45.45 Kb

QL-650TD, QL-550, QL-500 specifications

The Brother QL-500 is a high-performance label printer that caters to a variety of labeling needs, making it an essential tool for both personal and professional applications. Known for its versatility and ease of use, this device is particularly suited for small businesses, offices, and home users who require efficient labeling solutions.

One of the standout features of the Brother QL-500 is its printing speed. Capable of producing labels at a maximum speed of 68 labels per minute, it significantly reduces the time spent on printing tasks. This efficiency is further enhanced by its ability to print on a wide range of label sizes, including both standard and custom dimensions, which are perfect for addressing envelopes, shipping labels, and product stickers.

The QL-500 employs thermal printing technology, eliminating the need for expensive ink cartridges. This not only cuts down on operational costs but also ensures that labels are printed with sharp text and graphics. The printer utilizes Brother’s DK label rolls, which are available in various sizes and styles. Users can choose from pre-cut labels or continuous rolls, allowing for maximum flexibility depending on the specific labeling project at hand.

Another significant characteristic of the Brother QL-500 is its user-friendly interface. Featuring a convenient keypad and an LCD display, users can navigate the printer settings with ease. Additionally, it comes with built-in templates and a straightforward labeling software, facilitating the creation of personalized labels quickly. The software supports various formats, including text, barcodes, and images, making it versatile for different labeling applications.

Connectivity is also a strong point for the QL-500, as it can be easily connected to a computer via USB. This seamless integration enables users to design and print labels directly from their computers using the accompanying software. The printer is compatible with both Windows and macOS operating systems, ensuring a wide usability across different platforms.

Moreover, the Brother QL-500 is designed with a compact and lightweight build, making it easy to store and transport. Its durable construction guarantees longevity, making it a worthwhile investment in labeling technology. With its combination of speed, efficiency, and user-friendly features, the Brother QL-500 stands out as a reliable label printer for various applications. Whether for shipping, organization, or crafting, it meets the demands of modern users effectively.
Top Page Image Contents