Brother QL500 manual Creating labels using Microsoft Excel

Page 29

Microsoft Excel

With the Add-In function, you can directly copy text selected in Microsoft® Excel to a label layout.

Creating labels using Microsoft Excel

1 Open a Microsoft® Excel worksheet and select the cells that contain the text you want to include on the label.

2 On the Microsoft® Excel standard toolbar, click .

The [Brother P-touch Import Setup] dialog box appears.

3 In [Label Layout], make adjustments to

the line feed in the cells and click .

[Label Layout] enables you to change the way a label will be done its layout. When you select any listed item in the [Fields] box

and click , a new field is added to the [Label Layout] box.

You can enter spaces, line feeds, commas, and characters for each cell and print them on a label.

You can also preview the layout in the [Label Preview] box.

The Add-In Preview window appears.

29	Creating Labels with Other Applications

Introduction

Creating Labels (For Windows)

Creating Labels (For Macintosh)

Appendix

Image 29

Contents Software Users Guide Contents How to use the Users Guide Html Manual Setup & Operation Guide Quick Start Guide Symbols Used in this ManualAbout This Manual Manual StructureChoose the type of label you want to create Label Creation OverviewFrom Label Creation to Printing Create and print a label using P-touch Address Book Create and print a label using P-touch EditorCreate and print the label After creating a templateSelect 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 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 EditorSpecify the Printer item and click Printing a Help descriptionSelect the range of topics to be printed Click Creating Labels Efficiently Using the Label ListOpening the Label List Click File-Database-Label List„Form View Switching the Label List view„Record 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-ConnectClick 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 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 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 Deleting all the printer data Backing up label templatesSelect the printer to back up from, then Click Right click the printer, then select All DeleteChange settings as necessary Changing printer settings from the PCSelect the printer, then click Click SetOpening and editing data Starting up the P-touch LibraryPrinting labels Select the data you want to edit, then clickClick 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 Print Toolbar Layout WindowDatabase Toolbar Layout WindowProperty 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 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 the PS-9000 Print Server sold separately Using this printer as a Shared PrinterSharing the printer Network hub Brother QL- Series Network cable USB cableAvailable Commands Controlling with the ESC/P CommandsSerial Cables Brother QL-650TD/1050/1050NPrinting 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 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