Manuals / Brands / Computer Equipment / Printer / Brother / Computer Equipment / Printer

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

1 65

Download 65 pages, 4.6 Mb

Creating Labels with Other Applications

28

IntroductionCreating Labels (For Windows)Creating Labels (For Macintosh)Appendix

4Click .

The labels are printed.

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:

•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 Tool bar 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 record s are selected in Excel, use the buttons to show the other lines.

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.

Selected text Added field

Date of creation Date field

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

Layout Title field

All lines including the first line in text specified in the

Label Layout Body field

Content of cell specified in [Text Imported Into the

"code" Field of the Label List] Code field

Contents

Main Contents BROTHER QL-500/550/650TD Software User's Guide Introduction About This Manual Manual Structure Setup & Operation Guide Software User's Guide (this manual) Creating Labels (For Windows) Label Creation Overview 3 Printing directly Printing using the PC Starting P-touch Editor 1 [Brother P-touch]-[P-touch Editor 4.2]. How to Use P-touch Editor Layout window Creating an Address Label 1 2 3 Printing a Label 1 be printed to [1] and click . 2 button (Brother QL-550/650TD) or the Cut lever (Brother QL-500) of the printer. Page Creating Different Types of Labels Using the P-touch Editor Help Opening the Help files 1 2 P-touch Editor Help window Page Creating Labels Efficiently Using the Label List Opening the Label List 1 Switching the Label List view Page Layout Styles 2 3 Page Page Page Printing labels from the Label List 1 2 3 Using external database files 1 2 3 4 5 6 7 8 9 Page Creating Labels with Other Applications Add-In settings 2 [Brother P-touch]-[P-touch Tools]- [P-touch Editor 4.2 Add-Ins Utility]. Microsoft Word 1 select the text you want to print. 2 Toolbar in the Add-In Preview window How to add the Microsoft Word text to a label list Microsoft Excel Creating labels using Microsoft Excel 1 2 3 How to add the Microsoft Excel text to a label list Microsoft Outlook Creating labels using the Contacts data in Microsoft Outlook 1 and select the Contact information you want to include. 2 How to add the Microsoft Outlook text to a label list When importing data from the Contacts window: When importing other than Contact information: Starting the P-touch Address Book 2 How to Use the P-touch Address Book Layout window Creating a New Contact 1 2 New Contact form toolbar Contact form Importing the Contact Data Importing the contact data in CSV format 1 2 3 Page Printing the Label 1 2 button (Brother QL-550/650TD) or the Cut lever (Brother QL-500) of the printer. Print Options and label cutting How to Use the P-touch Transfer Manager (Brother QL-650TD Only) For the Brother QL-650TD only 4 5 6 LCD display on the Brother QL-650TD Transferring a Message 2 3 5 6 Backing Up the Data in the Main Unit 2 3 How to Use the P-touch Backup Manager (Brother QL-650TD Only) For the Brother QL-650TD Page Creating Labels (For Macintosh) Overview 3 Using the P-touch Editor Layout Window Draw Toolbar Print Toolbar Database Toolbar Layout Window Property Dock Page Printing the Label 1 2 3 Printing Options Tape Settings Halftone/Color P-touch Editor Page Users Guide (HTML Manual) Window Appendix Using this printer as a Shared Printer Using the PS-9000 Print Server (sold separately) Sharing the printer Available Commands Controlling with the ESC/P Commands Descriptions in this section apply only to the functions provided by the Brother QL-650TD. Brother QL-650TD Only Installing the Printer Driver 1 2 click [File]-[Printing Preferences]. Printing Directly from Other Applications 4 Page Uninstalling the Software Page Page 1 2 3 4 5 Using with Mac OS X Classic (Mac OS 8.6 ~ 9.2) Page 12 13 14 15 16 17 Page Product Specifications Operating Environment Specifications