Pitney Bowes LPS-1 manual Click in Microsoft Excel’s standard toolbar

Page 53

2 Click in Microsoft Excel’s standard toolbar.

P-touch Editor starts and the Add-In Preview window appears showing the newly created label.

• Refer to P-touch Editor Help for other methods of starting P-touch Editor from within Microsoft Excel.

•An error message appears if there is no data highlighted, or if the data highlighted contains an object not supported by P-touch Editor.

•Refer to “How Microsoft Excel data is added to the Label List” on page 49 for details of how the selected data is automatically added to the Label List.

•Refer to Add-In Preview window toolbar on page 47 for descriptions of each button.

•When several records are selected and imported, use the Previous/Next Record buttons to preview the label for the previous/next record.

•If you wish to import the last column of data (if numeric) into the code field, check the "Import Into Code Field" checkbox on the "Add-Ins" tab of the Options dialog box.

•The maximum number of rows that can be selected and printed in a single print job is 500.

•When printing, the records selected to be printed will be counted from the bottom of the list to the top. To print records 1 & 2 in a list of 10, select records 9 & 10 to be printed.

3 Click to print the label.

To edit or customize the text or label layout, click

.

The full P-touch Editor screen appears and you can edit the label.

„How Microsoft Excel data is added to the Label List

A new record is automatically created for each row selected and the text in the selected data is added to the following fields.

•The current date is added to the Date field.

•The content of the first cell in the row is added to the Title field.

•The content of the remaining cells in the row is added to the Body field.

•If the last cell selected in the row contains numeric data and hyphens only, the content of that cell can be added to both the Body field and the Code field.

z CREATING LABELS

Using P-touch Editor with Other Applications

49

Page 52 Page 54
Image 53
Page 52 Page 54
Contents To reorder supplies contact Page Contents Appendix Introduction Pitney Bowes Customer-Friendly Return PolicyLPS-1 General PrecautionsAC power cord Symbols Used in this GuideCD-ROM & Software Cutter unitStarter roll Unpacking Your LPS-1USB cable LPS-1 Label Printer LPS-1 Components„ Front Getting StartedLED Lamp Button descriptionsPlug the power supply cord into a standard electrical outlet Connecting to the Power SupplyAvailable supplies Installing the LA RollInstalling the LA Roll Installing the Paper Guide Software and Compatible Operating Systems Installation PrecautionsSoftware Overview It may take a short time for the dialog box to appear Installing the SoftwareCustomer Information dialog box appears Setup Type dialog box appearsTypical Following items will be installedCustom Start Copying Files dialog box appearsInstalling Software Click Finish Installation of the P-touch Editor software is now completedWhen using Microsoft Windows 98 SE Typical Start Copying Files dialog box appears Next Add New Hardware Wizard dialog box appears Add New Hardware Wizard dialog box appearsClick Next Installing Software User Registration dialog box appears Installation of the P-touch Editor software is now completed Click Cancel Driver Setup dialog box appears„ Re-installing the printer driver Confirmation dialog box appearsUninstalling P-touch Editor Version Uninstalling SoftwareInstallShield Wizard dialog box appears Confirm Uninstall dialog box appearsUninstall process is now completed Uninstalling the Printer DriverClick Finish to complete the uninstall Insert the appropriate LA Roll OverviewEnter the text There are two main methods of entering text on the labelCreating Labels Print the label Edit the labelTouch Editor provides a variety of editing functions Select an option in the dialog box, and then click OK Starting P-touch EditorLayout Window Using P-touch EditorCreating an Address Label Printing the Label Cut off the printed label using the CUT leverZPrint Optionsz „ Printing options and label cuttingOpening an Existing Label File Saving the LabelClick the in the Object dock Creating Bar Code LabelsBar Code Properties dialog box appears Bar code appears on the label in the layout work areaCreating Labels Sample Options Creating Other Types of LabelsTabs Using HelpMenu Topic Area„ Printing Help Select a topic in the Contents tab Click on the toolbarPrint Topics dialog box appears Select the range of topics to be printed, Then clickViews Label ListHow the Label List Works Repeat this for all necessary fields Using the Label List„ Form view New record appears in the list „ Choosing a Default Layout Style „ What is a Layout Style?„ When is this useful? Merge Fields dialog box appears Select Text from the pop-up menu Pop-up menu appearsField is added to the layout and displayed as text Repeat steps 1 and 2 to add more fields to the layoutSpecified labels are printed SettingsZPrint Range Optionsz Add-In Utility Using P-touch Editor with Other ApplicationsMicrosoft Word Change Paper Setting Print Settings buttonClick in Microsoft Word’s standard toolbar Toolbar Preview window„ How Microsoft Word data is added to the Label List Microsoft ExcelClick to print the label „ How Microsoft Excel data is added to the Label List Click in Microsoft Excel’s standard toolbarMicrosoft Outlook „ How Microsoft Outlook data is added to the Label List „ What is the database function? Using a Database„ Creating a name badge label using a database Open Database dialog box appearsField is added to the layout Creating Labels Print the labels using one of the methods below Cleaning the Print Head MaintenanceCleaning the Roller AppendixMaintenance Grip the tab and lift out the cutter unit Changing Cutter UnitWhat to do when TroubleshootingOperating Environment SpecificationsReplacement Blades for Cutter Unit Accessories For USA OnlyCleaning Sheet LA RollsAuto Format Templates IndexBody field 48, 49 Date fieldQuick Start Guide Record view Replacement Help Starting Uninstalling UsingSpecifications Standard toolbar Troubleshooting Typical setupAppendix Contact Information Service and SupportAccessories and Supplies
Top Page Image Contents