Pitney Bowes LPS-1 manual Using a Database, What is the database function?

Page 56

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

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 unitStarter roll Unpacking Your LPS-1USB cable 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 outletAvailable 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 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 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 appearsUninstalling Software Uninstalling P-touch Editor VersionInstallShield Wizard dialog box appears Confirm Uninstall dialog box appearsUninstall 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 labelCreating 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 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 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 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 layoutSpecified labels are printed SettingsZPrint Range Optionsz 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 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 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 Contact Information Service and SupportAccessories and Supplies