Manuals / Brother / Computer Equipment / Printer

Brother QL500 manual How to add the Microsoft Excel text to a label list

Models: QL500

1 67

Download 67 pages 3.8 Kb

Page 30

• 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 27.

•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	Title field
	Layout

	All lines including the first line in text specified in the	Body field
	Label Layout	Body field
	Label Layout

	Content of cell specified in [Text Imported Into the	Code field
	"code" Field of the Label List]	Code field
	"code" Field of the Label List]

30	Creating Labels with Other Applications

Introduction

Creating Labels (For Windows)

Creating Labels (For Macintosh)

Appendix

Image 30

Brother QL500 manual How to add the Microsoft Excel text to a label list

Contents

Software Users Guide Contents How to use the Users Guide Html Manual About This Manual Symbols Used in this ManualSetup & Operation Guide Quick Start Guide Manual StructureLabel Creation Overview From Label Creation to PrintingChoose the type of label you want to create Create and print the label Create and print a label using P-touch EditorCreate and print a label using P-touch Address Book After creating a templateHow to Use P-touch Editor Starting 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 cuttingClick File-Save As Saving a LabelOpening a Label File Click File-OpenCreating Different Types of Labels Touch Editor Help window Using the P-touch Editor HelpOpening the Help files Starting P-touch EditorPrinting a Help description Select the range of topics to be printed ClickSpecify the Printer item and click Opening the Label List Using the Label ListCreating Labels Efficiently Click File-Database-Label ListSwitching the Label List view „Record View„Form View Entering data Layout Styles „What is a Layout Style?„When is it useful to use a Layout Style? „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 Choose the Print Options Printing labels from the Label ListClick in the Print properties Print Range, specify the records to be printedStart the P-touch Editor and specify the label size Using external database filesPrepare a database file Click File-Database-ConnectSpecify how the file will be opened, Click Click Text10Select Bar Code 11Click in the Print propertiesAdd-In settings Creating Labels with Other ApplicationsCreating labels using Microsoft Word Microsoft WordToolbar in the Add-In Preview window How 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, clickHow to add the Microsoft Outlook text to a label list „When importing data from the Contacts window„When importing other than Contact information How to Use the P-touch Address Book Starting the P-touch Address BookLayout style selection view Menu barText toolbar Contact list combo boxEnter data for each item Creating a New ContactClick File-New Contact. Or, click New Contact form toolbarImporting the Contact Data Importing the contact data in CSV formatClick File-Import-Outlook Contacts Editing the Contact DataImporting the Outlook contact data Click File-Edit Contact. Or, clickPrinting the Label How to Use P-touch Transfer Manager & P-touch Library Starting up P-touch Transfer ManagerExplanations of the Icons Folder viewTransferring label templates from the PC to the printer Select the printer to transfer data toDrag the transfer data to the folder you just made Select the data or folder you want to Transfer,then click Click YesCreating and transferring a new message QL-650TD only Select the printer to back up from, then Click Backing up label templatesDeleting all the printer data Right click the printer, then select All DeleteSelect the printer, then click Changing printer settings from the PCChange settings as necessary Click SetPrinting labels Starting up the P-touch LibraryOpening and editing data Select the data you want to edit, then clickSearching labels Click Begin SearchProcedure for Creating and Printing Labels OverviewChoose 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 Database Toolbar Layout WindowPrint Toolbar Layout WindowProperty Dock Click on in the Property dock Select Standard Address LabelPrinting Options Click on in the print bar„Copies & Pages „Roll Setting „Halftone/Color„P-touch Editor Opening the Users Guide Html Manual How to use the Users Guide Html ManualInstalling the Users Guide Html Manual „SummaryUser’s Guide Html Manual Window „Main WindowSharing the printer Using this printer as a Shared PrinterUsing the PS-9000 Print Server sold separately Network hub Brother QL- Series Network cable USB cableSerial Cables Controlling with the ESC/P CommandsAvailable Commands Brother QL-650TD/1050/1050NFrom Control Panel, open Printers and Faxes Printers Installing the Printer DriverPrinting Directly from Other Applications Select each item and clickClose the Printers and Faxes Printers window Printing from Other Applications Click File-PrintSelect Brother QL-500/550/650TD/1050/ 1050N Uninstalling the Software Uninstalling the P-touch EditorFor Windows Uninstalling the Printer Driver For MacintoshClick Delete Applications-P-touch Editor 3.2 folder Specifications Product SpecificationsOperating Environment