Pitney Bowes LPS-1 manual Microsoft Excel, Click to print the label

Page 52

CREATING LABELS

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 Word data is added to the Label List

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

•The current date is added to the Date field.

•The first line is added to the Title field.

•All remaining lines are added to the Body field.

• Uncheck the "Label List" checkbox in the Add-In Preview window when you do not want to register the data in the Label List.

•The data is copied onto a label formatted with the default Layout Style. To change the Layout Style, click

to open the full P-touch Editor screen and edit the layout or apply a different Layout Style. Refer to “Creating Labels Using a Layout Style and Data from the Label List” on page 41 for details.

Microsoft Excel

You can start the P-touch Add-In and copy the highlighted data directly onto a label from Microsoft Excel. The highlighted data is copied as text and automatically added to new records created in the Label List. The Title, Body and Code fields of the new record are then merged into a new label layout, which is displayed in the Add-In Preview window.

„Creating a label using data from Microsoft Excel

1Open a Microsoft Excel worksheet and select the data you wish to place on a label. To select the data, highlight the text.

48

Using P-touch Editor with Other Applications

Page 51 Page 53
Image 52
Page 51 Page 53
Contents To reorder supplies contact Page Contents Appendix Pitney Bowes Customer-Friendly Return Policy IntroductionGeneral Precautions LPS-1Symbols Used in this Guide AC power cordCD-ROM & Software Cutter unitUSB cable Unpacking Your LPS-1Starter roll LPS-1 Components LPS-1 Label Printer„ Front Getting StartedButton descriptions LED LampConnecting to the Power Supply Plug the power supply cord into a standard electrical outletInstalling the LA Roll Installing the LA RollAvailable supplies Installing the Paper Guide Software Overview Installation PrecautionsSoftware and Compatible Operating Systems Installing the Software It may take a short time for the dialog box to appearSetup Type dialog box appears Customer Information dialog box appearsFollowing items will be installed TypicalCustom Start Copying Files dialog box appearsInstalling Software Installation of the P-touch Editor software is now completed Click FinishWhen using Microsoft Windows 98 SE Typical Start Copying Files dialog box appears Click Next Add New Hardware Wizard dialog box appearsNext Add New Hardware Wizard dialog box appears Installing Software User Registration dialog box appears Installation of the P-touch Editor software is now completed Driver Setup dialog box appears Click Cancel„ Re-installing the printer driver Confirmation dialog box appearsUninstalling Software Uninstalling P-touch Editor VersionInstallShield Wizard dialog box appears Confirm Uninstall dialog box appearsClick Finish to complete the uninstall Uninstalling the Printer DriverUninstall process is now completed Overview Insert the appropriate LA RollEnter the text There are two main methods of entering text on the labelTouch Editor provides a variety of editing functions Edit the labelCreating Labels Print the label Starting P-touch Editor Select an option in the dialog box, and then click OKUsing P-touch Editor Layout WindowCreating an Address Label Cut off the printed label using the CUT lever Printing the LabelZPrint Optionsz „ Printing options and label cuttingSaving the Label Opening an Existing Label FileCreating Bar Code Labels Click the in the Object dockBar Code Properties dialog box appears Bar code appears on the label in the layout work areaCreating Labels Creating Other Types of Labels Sample OptionsUsing Help TabsMenu Topic AreaSelect a topic in the Contents tab Click on the toolbar „ Printing HelpPrint Topics dialog box appears Select the range of topics to be printed, Then clickHow the Label List Works Label ListViews „ Form view Using the Label ListRepeat this for all necessary fields New record appears in the list „ When is this useful? „ What is a Layout Style?„ Choosing a Default Layout Style Merge Fields dialog box appears Pop-up menu appears Select Text from the pop-up menuField is added to the layout and displayed as text Repeat steps 1 and 2 to add more fields to the layoutZPrint Range Optionsz SettingsSpecified labels are printed Using P-touch Editor with Other Applications Add-In UtilityMicrosoft Word Print Settings button Change Paper SettingClick in Microsoft Word’s standard toolbar Toolbar Preview windowClick to print the label Microsoft Excel„ How Microsoft Word data is added to the Label List Click in Microsoft Excel’s standard toolbar „ How Microsoft Excel data is added to the Label ListMicrosoft Outlook „ How Microsoft Outlook data is added to the Label List Using a Database „ What is the database function?„ 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 Maintenance Cleaning the Print HeadCleaning the Roller AppendixMaintenance Changing Cutter Unit Grip the tab and lift out the cutter unitTroubleshooting What to do whenSpecifications Operating EnvironmentAccessories For USA Only Replacement Blades for Cutter UnitCleaning Sheet LA RollsIndex Auto Format TemplatesBody field 48, 49 Date fieldHelp Starting Uninstalling Using Quick Start Guide Record view ReplacementSpecifications Standard toolbar Troubleshooting Typical setupAppendix Accessories and Supplies Service and SupportContact Information
Top Page Image Contents