Manuals / Brother / Computer Equipment / Label Maker

Brother TD-4000 How to add text from Microsoft Excel to a Label List, Creating Labels, Appendix

Models: TD-4000

1 52

Download 52 pages 6.19 Kb

Page 24

How to add text from Microsoft® Excel® to a Label List

How to add text from Microsoft® Excel® to a Label List

For first time use, the message "Record data in the Label List?" is displayed. If you click Yes, new records are automatically created in the Label List and the text is added to each field shown below from next time you register the text: Each time you add new information into your label list it also records the following information for your reference.

	The 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]

If you clicked No when the message "Record data in the Label List?" is displayed, but want to register, go to [Tools]-[Options], and check "Automatically Record Data Imported With Add-in."

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

Introduction

Customizing Labels

Creating Labels

Appendix

Image 24

Brother TD-4000 How to add text from Microsoft Excel to a Label List, Introduction Customizing Labels, Creating Labels

Contents

Software Users Guide TD-seriesIntroduction Customizing Labels Creating Labels Appendix Contents Printing the list of label templates Introduction TrademarksAbout this Guide Manual StructureSymbols used in this Guide P-touch Template manualIntroduction Customizing Labels Creating Labels AppendixCustomizing Labels Add new paper format1 For Windows XP For Windows Vista3 Click Paper Size Setup 1 New2 Edit 3 Delete5 Enter the settings for the paper to be used, and then click Add 4 Click New6 Click Exit IntroductionIntroduction Customizing LabelsCreating Labels Distributing only paper formatsCreating Labels Label creation overviewFrom label creation to printing 2 Prepare the appropriate RD Roll for the label you want to createHow to use the P-touch Editor Starting P-touch Editor1 Click Start-All Programs Programs Brother P-touch-P-touch Editor 2 Choose an option in the New/Open dialog box and clickLayout window „Express Mode2 Command bar 7 Mode Switch„Professional Mode 7 Mode Switch1 Menu bar 2 Standard toolbar„Snap Mode 2 Snap mode appearsappears. Click Introduction Customizing LabelsStart P-touch Editor Help When you start the P-touch Editor 5.0 and the„Start from Start button „Start from New/Open dialogPrinting the Help description 1 In the Contents tab, choose any topic you want to print2 Click on the Toolbar 3 Choose the range of topics to be printed and clickSetting the Printer Driver Printing directly from other applications1 For Windows XP For Windows Vista3 Choose each item and click 4 Close the Printers windowIntroduction Customizing Labels Creating LabelsPrinting from other applications When you click Page Layout the ribbon appears. Then clickSetup 1 Click andCreating labels with other applications by using the Add-In function Registering and canceling the Add-In functionFor details or installation information, see the P-touch Editor Help 1 Click Start-All Programs Brother P-touch-P-touch ToolsExpress Mode Introduction Customizing LabelsCreating Labels AppendixCreating labels using Microsoft Word Microsoft Word2 On the Microsoft Word ribbon/standard toolbar, click Introduction Customizing LabelsCreating labels using Microsoft Excel Microsoft Excel3 In Label Layout, make adjustments to the 2 On the Microsoft Excel ribbon/standard toolbar, clickHow to add text from Microsoft Excel to a Label List Introduction Customizing LabelsCreating Labels AppendixCreating labels using the Contacts data in Microsoft Outlook Microsoft Outlook3 In Label Layout, make adjustments to the 2 On the Microsoft Outlook ribbon/standard toolbar, clickHow to add text from Microsoft Outlook to a Label List Introduction Customizing LabelsCreating Labels AppendixHow to use P-touch Transfer Manager & P-touch Library Starting up P-touch Transfer ManagerLayout window 1 MenuTransferring label templates from the PC to the printer via USB Explanations of the Icons1 Select the printer to transfer data to Introduction Customizing Labels3 Drag the transfer data to the folder you just made 5 Select the data or folder you want to transfer, then click6 Click OK Introduction Customizing LabelsTransfer the templates to the printer via network Start BRAdmin Professional A or Web BRAdmin BClick to save the registered template in .blf formatBacking up label templates 2 Select the printer to back up from, then click3 Click OK Introduction Customizing LabelsDeleting label templates in the printer 2 Right click the printer, then select All Delete3 Click OK Introduction Customizing LabelsStarting up P-touch Library Opening and editing dataPrinting labels 1 Choose the data you want to edit, then clickSearching labels 3 Click Begin Search1 Click Introduction Customizing LabelsTransferring label templates with P-touch Transfer Express 1. Preparing P-touch Transfer ExpressSelect your region/country - Choose your product - Downloads 2 Download Transfer Express to any location on the computer2. Transferring the label template to P-touch Transfer Manager 3. Saving the label template as a Transfer Package file .pdz1 In the folder view, select Configurations 1 In P-touch Editor, open the label template to be transferred2 Select the label template to be distributed 3 Click File - Save Transfer File4 Type in the name, and then click Save Introduction Customizing Labels1 Move the Transfer Package file .pdz to the folder Transfer Express 2 Distribute all files in the folder Transfer Express to the userIntroduction Customizing Labels5. Transferring the Transfer Package file .pdz to TD-4000/4100N Using a USB cable, connect the TD-4000/4100N to the computerWhen there is a single Transfer Package Turn on the TD-4000/4100NClick Transfer Click Yes 5 Click OKIntroduction Customizing Labels Creating LabelsPrinting the list of label templates 1 Install a roll of labels with a width of 250.8mm or more2 Hold down the FEED button Introduction Customizing LabelsPrinting labels using P-touch templates P-touch Template functionPreparation Barcode printing Î pagePreset template printing 3 Scan the “P-touch template command” barcode6 The specified label is printed Barcode printing Barcode printingIntroduction Customizing Labels Creating LabelsAppendix 7 Scan the key barcode whose data is to be used in the database file Introduction Customizing LabelsCreating Labels AppendixDistributed printing Printing labels distributed to multiple printersfor distributed printing.1 Introduction Customizing Labels6 Click OK to close the label size setting window 7 Click OK to close the “Distributed Printing Settings” window5 Specify the label size to be used for printing A.If only one printer has been selectedGeneral procedure for the P-touch Template function Appendix3 Scan the “P-touch template command” barcode 4 Scan the “Basic settings” barcodeList of barcodes for specifying settings P-touch template command Initialize + begin specifying settingsBasic settings IntroductionPreset template number Preset templatePreset template Preset templatePreset template Preset templatePreset template Select template Delimiter Begin printing