Brother QL500 Using external database files, Prepare a database file, Click File-Database-Connect

Page 23

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.

23	Creating Labels Efficiently

Creating Labels (For Windows)

Creating Labels (For Macintosh)

Appendix

Image 23

Contents Software Users Guide Contents How to use the Users Guide Html Manual Manual Structure Symbols Used in this ManualSetup & Operation Guide Quick Start Guide About This ManualChoose the type of label you want to create Label Creation OverviewFrom Label Creation to Printing After creating a template Create and print a label using P-touch EditorCreate and print a label using P-touch Address Book Create and print the labelSelect an option in the Startup dialog box and click How to Use P-touch EditorStarting P-touch Editor Layout window Creating an Address Label Print Options and label cutting Printing a LabelClick File-Open Saving a LabelOpening a Label File Click File-Save AsCreating Different Types of Labels Starting P-touch Editor Using the P-touch Editor HelpOpening the Help files Touch Editor Help windowSpecify the Printer item and click Printing a Help descriptionSelect the range of topics to be printed Click Click File-Database-Label List Using the Label ListCreating Labels Efficiently Opening the Label List„Form View Switching the Label List view„Record View Entering data „Changing the Layout Style for each DK Roll „What is a Layout Style?„When is it useful to use a Layout Style? Layout StylesReturn 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 Print Range, specify the records to be printed Printing labels from the Label ListClick in the Print properties Choose the Print OptionsClick File-Database-Connect Using external database filesPrepare a database file Start the P-touch Editor and specify the label sizeClick Text Specify how the file will be opened, Click11Click in the Print properties 10Select Bar CodeCreating Labels with Other Applications Add-In settingsToolbar in the Add-In Preview window Creating labels using Microsoft WordMicrosoft Word How 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 Outlook„When importing other than Contact information How to add the Microsoft Outlook text to a label list„When importing data from the Contacts window Starting the P-touch Address Book How to Use the P-touch Address BookContact list combo box Menu barText toolbar Layout style selection viewNew Contact form toolbar Creating a New ContactClick File-New Contact. Or, click Enter data for each itemImporting the contact data in CSV format Importing the Contact DataClick File-Edit Contact. Or, click Editing the Contact DataImporting the Outlook contact data Click File-Import-Outlook ContactsPrinting the Label Starting up P-touch Transfer Manager How to Use P-touch Transfer Manager & P-touch LibraryFolder view Explanations of the IconsDrag the transfer data to the folder you just made Transferring label templates from the PC to the printerSelect the printer to transfer data to Click Yes Select the data or folder you want to Transfer,then clickCreating and transferring a new message QL-650TD only Right click the printer, then select All Delete Backing up label templatesDeleting all the printer data Select the printer to back up from, then ClickClick Set Changing printer settings from the PCChange settings as necessary Select the printer, then clickSelect the data you want to edit, then click Starting up the P-touch LibraryOpening and editing data Printing labelsClick Begin Search Searching labelsChoose the label you want to create Procedure for Creating and Printing LabelsOverview Entering text Î Creating labels Î Double-click the P-touch Editor 3.2 folder Using the P-touch EditorStarting the P-touch Editor Layout Window Layout WindowPrint Toolbar Database ToolbarProperty Dock Select Standard Address Label Click on in the Property dock„Copies & Pages Printing OptionsClick on in the print bar „P-touch Editor „Roll Setting„Halftone/Color „Summary How to use the Users Guide Html ManualInstalling the Users Guide Html Manual Opening the Users Guide Html Manual„Main Window User’s Guide Html Manual WindowNetwork hub Brother QL- Series Network cable USB cable Using this printer as a Shared PrinterUsing the PS-9000 Print Server sold separately Sharing the printerBrother QL-650TD/1050/1050N Controlling with the ESC/P CommandsAvailable Commands Serial CablesSelect each item and click Installing the Printer DriverPrinting Directly from Other Applications From Control Panel, open Printers and Faxes PrintersClose the Printers and Faxes Printers window Select Brother QL-500/550/650TD/1050/ 1050N Printing from Other ApplicationsClick File-Print For Windows Uninstalling the SoftwareUninstalling the P-touch Editor For Macintosh Uninstalling the Printer DriverClick Delete Applications-P-touch Editor 3.2 folder Product Specifications SpecificationsOperating Environment