Using a Database | Pitney Bowes LPS-1 instruction

CREATING LABELS

Using a Database

What is the database function?

The database function allows you to use existing data from another source to quickly create custom labels containing database content - for example name/address labels or inventory labels with codes. The supported formats are mdb (MS Access), csv (generic format) and xls (MS Excel).

Creating a name badge label using a database

This procedure describes how to retrieve the database information and associate it to the layout.

1 In the Page properties box, select Visitor Name Badge Label from the pull-down list of label types.

The tape length and width settings are automatically set to the size of a Shipping label.

If the Page property box is not displayed in the Property dock click to open it.

2 Prepare a rough label layout for the label you want to create.

3 To retrieve the database information and associate it to the layout (merge), click the File menu, point to Database, and then click Connect.

The Open Database dialog box appears.

52

Using P-touch Editor with Other Applications

Image 56

Pitney Bowes LPS-1 Using a Database, „ What is the database function?, „ Creating a name badge label using a database

Contents

To reorder supplies contact Page Contents Appendix Pitney Bowes Customer-Friendly Return Policy Introduction General Precautions LPS-1 Symbols Used in this Guide AC power cordCD-ROM & Software Cutter unit Starter roll Unpacking Your LPS-1USB cable LPS-1 Components LPS-1 Label Printer„ Front Getting Started Button descriptions LED Lamp Connecting to the Power Supply Plug the power supply cord into a standard electrical outlet Available supplies Installing the LA RollInstalling the LA Roll Installing the Paper Guide Software and Compatible Operating Systems Installation PrecautionsSoftware Overview Installing the Software It may take a short time for the dialog box to appear Setup Type dialog box appears Customer Information dialog box appears Following items will be installed TypicalCustom Start Copying Files dialog box appears Installing Software Installation of the P-touch Editor software is now completed Click Finish When 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 Driver Setup dialog box appears Click Cancel„ Re-installing the printer driver Confirmation dialog box appears Uninstalling Software Uninstalling P-touch Editor VersionInstallShield Wizard dialog box appears Confirm Uninstall dialog box appears Uninstall process is now completed Uninstalling the Printer DriverClick Finish to complete the uninstall Overview Insert the appropriate LA RollEnter the text There are two main methods of entering text on the label Creating Labels Print the label Edit the labelTouch Editor provides a variety of editing functions Starting P-touch Editor Select an option in the dialog box, and then click OK Using P-touch Editor Layout Window Creating an Address Label Cut off the printed label using the CUT lever Printing the LabelZPrint Optionsz „ Printing options and label cutting Saving the Label Opening an Existing Label File Creating Bar Code Labels Click the in the Object dockBar Code Properties dialog box appears Bar code appears on the label in the layout work area Creating Labels Creating Other Types of Labels Sample Options Using Help TabsMenu Topic Area Select 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 click Views 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 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 layout Specified labels are printed SettingsZPrint Range Optionsz Using P-touch Editor with Other Applications Add-In Utility Microsoft Word Print Settings button Change Paper SettingClick 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 Click in Microsoft Excel’s standard toolbar „ How Microsoft Excel data is added to the Label List Microsoft 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 appears Field is added to the layout Creating Labels Print the labels using one of the methods below Maintenance Cleaning the Print HeadCleaning the Roller Appendix Maintenance Changing Cutter Unit Grip the tab and lift out the cutter unit Troubleshooting What to do when Specifications Operating Environment Accessories For USA Only Replacement Blades for Cutter UnitCleaning Sheet LA Rolls Index Auto Format TemplatesBody field 48, 49 Date field Help Starting Uninstalling Using Quick Start Guide Record view ReplacementSpecifications Standard toolbar Troubleshooting Typical setup Appendix Contact Information Service and SupportAccessories and Supplies