Brother TD-4000 appendix On the Microsoft Excel ribbon/standard toolbar, click

Page 23

Microsoft® Excel®

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

Creating labels using Microsoft® Excel®

1 Open a Microsoft® Excel® worksheet and select the cells of text you want included in the label from your Excel spreadsheet.

Introduction

2 On the Microsoft® Excel® ribbon/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 your text is displayed/printed.

When you choose 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 remove fields in this screen by highlighting the field and pressing the delete key on your keyboard.

• For details on how to automatically add the text to a Label List, see "How to add text from Microsoft® Excel® to a Label List" on page 24.

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

23	Creating labels with other applications by using the Add-In function

Customizing Labels

Creating Labels

Appendix

Image 23

Contents Software Users Guide Contents Appendix Manual Structure TrademarksAbout this Guide Touch Template manual Symbols used in this GuideAdd new paper format Customizing LabelsEdit Click Paper Size SetupClick Exit Click NewDistributing only paper formats From label creation to printing Label creation overviewChoose an option in the New/Open dialog Box and click How to use the P-touch EditorStarting P-touch Editor Layout window „Professional Mode Snap mode appears „Snap ModeRight click the mouse and choose P-touch Editor Help Start P-touch Editor HelpClick Help menu and choose P-touch Editor Help Specify the Printer and click Printing the Help descriptionFor Windows Setting the Printer DriverPrinting directly from other applications Close the Printers window Choose each item and clickChoose Brother Printing from other applicationsClick Registering and canceling the Add-In function Creating Labels Microsoft Word Creating labels using Microsoft WordOn the Microsoft Excel ribbon/standard toolbar, click Microsoft ExcelHow to add text from Microsoft Excel to a Label List On the Microsoft Outlook ribbon/standard toolbar, click Microsoft OutlookHow to add text from Microsoft Outlook to a Label List Starting up P-touch Transfer Manager How to use P-touch Transfer Manager & P-touch LibrarySelect the printer to transfer data to Explanations of the IconsClick OK Drag the transfer data to the folder you just madeSelect the data or folder you want to Transfer, then click Transfer the templates to the printer via network Select the printer to back up from, then Click Backing up label templatesRight click the printer, then select All Delete Deleting label templates in the printerChoose the data you want to edit, then Click Starting up P-touch LibraryOpening and editing data Printing labelsClick Begin Search Searching labelsPreparing P-touch Transfer Express Transferring label templates with P-touch Transfer ExpressSaving the label template as a Transfer Package file .pdz Folder view, select ConfigurationsTransferring the label template to P-touch Transfer Manager Type in the name, and then click Save Select the label template to be distributedClick File Save Transfer File Introduction PtTrExp.exe Click Transfer When there is a single Transfer PackageTurn on the TD-4000/4100N File .pdz within the folder containingClick Transfer Click Yes List of label templates is printed Printing the list of label templatesPreparation Printing labels using P-touch templatesTouch Template function Scan the P-touch template command barcode Preset template printingBarcode printing Creating Labels Database-assisted label printing Distributed printing Printing labels distributed to multiple printersClick OK to start distributed printing If multiple printers have been selectedDatabase-assisted label printing General procedure for the P-touch Template functionScan the Basic settings barcode Barcode printingBasic settings List of barcodes for specifying settingsFor entering numbers*1 Preset template number Select template Delimiter Begin printing