Brother QL-550, QL-500, QL-650TD appendix How to add the Microsoft Excel text to a label list

Page 28

• For details on how to automatically add the selected text to a label list, refer to "How to add the Microsoft® Excel text to a label list" described below.

•For details on the Toolbar of the Add-In Preview window, refer to Î"Toolbar in the Add-In Preview window" on page 25.

•If you want to include the data into the Code field of the label list, select [Text Imported Into the "Code" Field of the Label List] in the [Brother P-touch Import Setup] dialog box.

•When multiple records are selected in Excel, use the buttons to show the other lines.

4 Click .

The labels are printed.

To edit or customize the text or label layout, click .

This operation opens the P-touch Editor layout window, which allows you to edit labels.

How to add the Microsoft Excel text to a label list

If you want to register the text in the label list, check the [Record In Label List] check box in the Add-In Preview window. New records are automatically created and the selected text is added to each field as shown below:

Selected text

Added field

 

 

Date of creation

Date field

 

 

The first line in the text that is specified in the Label

Title field

Layout

 

 

 

All lines including the first line in text specified in the

Body field

Label Layout

 

 

 

Content of cell specified in [Text Imported Into the

Code field

"code" Field of the Label List]

 

 

 

28

Creating Labels with Other Applications

Introduction

Creating Labels (For Windows)

Creating Labels (For Macintosh)

Appendix

Page 27 Page 29
Image 28
Page 27 Page 29
Contents Software Users Guide Symbols Used in this Manual Setup & Operation GuideAbout This Manual Manual StructureFrom Label Creation to Printing Label Creation OverviewChoose the type of label you want to create Create and print a label using P-touch Editor Create and print a label using P-touch Address BookCreate and print the label Use an application from another manufacturerStarting P-touch Editor How to Use P-touch EditorSelect an option in the Startup dialog box and click Layout window Creating an Address Label Printing a Label Print Options and label cuttingSaving a Label Opening a Label FileClick File-Save As Click File-OpenCreating Different Types of Labels Using the P-touch Editor Help Opening the Help filesTouch Editor Help window Starting P-touch EditorSelect the range of topics to be printed Click Printing a Help descriptionSpecify the Printer item and click Using the Label List Creating Labels EfficientlyOpening the Label List Click File-Database-Label List„Record View Switching the Label List view„Form View Entering data „What is a Layout Style? „When is it useful to use a Layout Style?Layout Styles „Changing the Layout Style for each DK Roll„Using a Layout Style to create labels Return to the Layout window to check the labels„Creating and registering a new Layout Style Click File-New11Select the layout style you have created Click Printing labels from the Label List Click in the Print propertiesChoose the Print Options Print Range, specify the records to be printedUsing external database files Prepare a database fileStart the P-touch Editor and specify the label size Click File-Database-ConnectSpecify how the file will be opened, Click 10Select Bar Code 11Click in the Print propertiesAdd-In settings Creating Labels with Other ApplicationsCreating labels using Microsoft Word 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 Creating labels using Microsoft Excel Microsoft ExcelHow to add the Microsoft Excel text to a label list Microsoft Outlook On the Microsoft Outlook standard toolbar, click„When importing data from the Contacts window How to add the Microsoft Outlook text to a label list„When importing other than Contact information How to Use the P-touch Address Book Starting the P-touch Address BookMenu bar Text toolbarLayout style selection view Contact list combo boxCreating a New Contact Click File-New Contact. Or, clickEnter data for each item New Contact form toolbarImporting the Contact Data Importing the contact data in CSV formatEditing the Contact Data Importing the Outlook contact dataClick File-Import-Outlook Contacts Click File-Edit Contact. Or, clickPrinting the Label This is not available for the Brother QL-500/550 Creating and Transferring the Download Template DataClick File-Transfer Template LCD display on the Brother QL-650TD D01Address 1-1/7 x 3-1/2Transferring a Message Creating Labels For Macintosh Appendix How to Use the P-touch Backup Manager Brother QL-650TD Only Backing Up the Data in the Main UnitClick the Printer PC tab Select the data you want to back up ClickRestoring the backed up data to the Brother QL-650TD Click the PC- Printer tabOverview Procedure for Creating and Printing LabelsChoose the label you want to create Entering text Î Creating labels Î Using the P-touch Editor Starting the P-touch EditorDouble-click the P-touch Editor 3.2 folder Double-clickLayout Window Print ToolbarDatabase Toolbar Layout WindowProperty Dock Click on in the Property dock Select Standard Address LabelClick on in the print bar Printing Options„Copies & Pages „Halftone/Color „Tape Settings„P-touch Editor How to use the Users Guide Html Manual Installing the Users Guide Html ManualOpening the Users Guide Html Manual „SummaryUser’s Guide Html Manual Window „Main WindowUsing the PS-9000 Print Server sold separately Using this printer as a Shared PrinterSharing the printer Controlling with the ESC/P Commands Available CommandsSerial Cables Brother QL-650TDInstalling the Printer Driver Printing Directly from Other ApplicationsFrom Control Panel, open Printers and Faxes Printers Select each item and clickClose the Printers and Faxes Printers window Click File-Print Printing from Other ApplicationsSelect Brother QL-500/550/650TD Uninstalling the P-touch Editor Uninstalling the SoftwareFor Windows Uninstalling the Printer Driver For MacintoshCreating Labels For Windows Creating Labels For Macintosh Click Install Start up Macintosh, and insert the CD-ROM into CD-ROM driveDouble click Driver Installer 15Connect the USB cable to the USB port of Macintosh 18Click OK when the screen shown right is displayed Product Specifications 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