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

• 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 Structure Label 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 template How 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 cutting Click File-Save As Saving a LabelOpening a Label File Click File-Open Creating Different Types of Labels Touch Editor Help window Using the P-touch Editor HelpOpening the Help files Starting P-touch Editor Printing 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 List Switching 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-New 11Select 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 printed Start the P-touch Editor and specify the label size Using external database filesPrepare a database file Click File-Database-Connect Specify how the file will be opened, Click Click Text 10Select Bar Code 11Click in the Print properties Add-In settings Creating Labels with Other Applications Creating 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 Excel How to add the Microsoft Excel text to a label list Microsoft Outlook On the Microsoft Outlook standard toolbar, click How 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 Book Layout style selection view Menu barText toolbar Contact list combo box Enter data for each item Creating a New ContactClick File-New Contact. Or, click New Contact form toolbar Importing the Contact Data Importing the contact data in CSV format Click File-Import-Outlook Contacts Editing the Contact DataImporting the Outlook contact data Click File-Edit Contact. Or, click Printing the Label How to Use P-touch Transfer Manager & P-touch Library Starting up P-touch Transfer Manager Explanations of the Icons Folder view Transferring 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 Yes Creating 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 Delete Select the printer, then click Changing printer settings from the PCChange settings as necessary Click Set Printing labels Starting up the P-touch LibraryOpening and editing data Select the data you want to edit, then click Searching labels Click Begin Search Procedure 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 Window Property Dock Click on in the Property dock Select Standard Address Label Printing 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 „Summary User’s Guide Html Manual Window „Main Window Sharing the printer Using this printer as a Shared PrinterUsing the PS-9000 Print Server sold separately Network hub Brother QL- Series Network cable USB cable Serial Cables Controlling with the ESC/P CommandsAvailable Commands Brother QL-650TD/1050/1050N From Control Panel, open Printers and Faxes Printers Installing the Printer DriverPrinting Directly from Other Applications Select each item and click Close 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 Macintosh Click Delete Applications-P-touch Editor 3.2 folder Specifications Product Specifications Operating Environment