Import your data into the upsAddress table | Lexmark Version 3.0

Figure 20: Format your address data into columns with these exact names.

Step 2: Import your data into the upsAddress table

A table within the database named Exchange.mdb controls the Address Book feature of MASTERFORM. This database sits in your MASTERFORM installation directory. By default, the directory is C:\MF_UPS.

You must have Microsoft Access installed on your computer to open and use the Exchange.mdb file. If you have Microsoft Access, simply browse to the installation directory (C:\MF_UPS) and double-click the file Exchange.mdb.

Inside Exchange, click the Tables tab to find the table named upsAddress. This is the table that stores your address data. (See Figure 21.) Again, it is configured with the following column names:

CompanyName, Address, City, State, Postal Code, Contact, Phone

Figure 21: Highlight the table named upsAddress before importing.

IMPORTANT: The upsAddress table itself should not be open when you go to import. Make sure the table is closed but highlighted, then perform the following steps:

(a)Select Get External Data from the File menu. You should see two options when you select Get External Data: “Import”and “Link Tables.” Select Import as shown in Figure 22.

(b)Browse to find your address data (the file you want to import). Make sure to change the Files of Type drop-down list so that you can see the appropriate files. For example, if your data is in an Excel worksheet, the Files of Type field should read “Microsoft Excel.” Otherwise, you won’t be able to see any Excel files.

(c)When you’ve found your address data, highlight the file name by clicking it once, then click Import. This will bring you into the Access Import Wizard. (See Figure 23.)

70

71

Image 36

Lexmark Version 3.0 manual Import your data into the upsAddress table

Contents

User’s Guide User’s Guide East Pine Street, Suite Seattle, WA Toll free Local Fax Contents Getting Started Using Printing the Shipper’s Installation and Setup General features Introduction to Masterform Installing Masterform for UPS Domestic Edition Download New UPS Chemical Table featureProfessional and Military Edition Suites What’s my name & password? Structure of MasterformDomestic or International? Where to install Masterform Where to get formsNew shipping paper design for laser printers Install the software Set up the System DSN connectionTo manually set up the System DSN connection Sending your Masterform shipments to UPS OnLine WorldShip Hazmat Confirm that Hazmat is now listed, then click OK Send hazmat shipping paper data to WorldShip Specify a hazmat package in WorldShipTo specify a hazmat package in WorldShip Deleting HAZMAT/DG records Support and Resources Technical Support and Contact Information By PhoneVia E-mail Online Info Other Contacts DOT ContactLabelmaster Software Hardware Recommendations Chemical table resources Remember Managing Templates and Addresses TemplatesAddresses File Extensions Masterform Masterform Setup Setup Accounts Bypass Authorization Screen Save template by defaultPackage Label Warning Allow Proper Shipping Name edits Shipping under multiple accounts Security Defining user names and passwords To add users to the list Why are my log book numbers repeating? How log book numbers work Making, naming, and saving templates To Save a Template What is a template? When should I use templates?What should I name my template? How do I reenter a saved template? Working with templates Deleting templates Editing the proper shipping name PSNTo select the Edit PSN option Using an Exemption Packaging number Confirming the labels required for your package Turning off the Labels Required field warning Pre-printing forms for future use Features and Options Writing notes inside To write a noteTo read a note Entering addresses in the Address Book Import Excel or Access address data to the Address Book Prepare your data Import your data into the upsAddress table Format your address data into columns with these exact names Select Get External Data Import from the File menu Exporting addresses from the Address Book To export addresses from Masterform Select how you want to save the table Setting default field values To set a default field valueTo remove a default field value Saving multiple field values Viewing the regulations Form-Fill Wizard Step by Step Screen 1 Shipment Template Choose a template and a form type to begin Screen 2 Shipper Information Screen 3 Shipment InformationScreen 4 Proper Shipping Name Screen 5 The Chemical Table Screen 6 Ground or Air Shipment Screen 7 Print PreviewQuantity and Unit of Measure UOM Limitations Add up to three materials Screen 8 Print and Save Shipment Template Print Preview you can Printing the Hazardous Materials Shipping Paper General Printing Overview Form 1 Hazmat Shipping PaperForm 2 Shipper’s Certification Printers Installing a printer Creating a custom paper size tractor To manually create a custom paper size Windows 95 Select the option Use Specific Printer67 in 800 To manually create a custom paper size Windows NT Changing the printer driver Suggested printer drivers Changing the Emulation Mode on the printer tractor To change to the Epson driver Setting the Margins To change the Emulation Mode on an Okidata 320/321If you are using the tractor form If you are using the new laser form Moving fields on the form use the Nudge tool Nudge tool To use the Nudge tool Increase or decrease the size of printed text Add or remove lines from the printed form Printing the Shipper’s Certification Printing the certification To print a Shipper’s Certification Saving shipments to the certification Removing mistakes or duplicates from the certificationSave to Shipper’s Certification? Purge old certification records Click Purge Data Troubleshooting Overview Printing gibberish or symbols Account number not in the drop-down list Custom paper size not in paper size list Printer feeds forms up too farShipper’s Certification prints on two pages Printer prints blank pages Laser forms are not lining up properly Log book numbers are repeating Can’t edit the PSN proper shipping nameText you entered isn’t an item on the list UPS WorldShip, the HAZMAT/DG Reference list is grayed out UPS WorldShip, the HAZMAT/DG Reference list is blank Unexpected error occured Subsystem Run Time Error 9 in Configure Reports Do you want to convert or enable the database? You do not have a license with MS Access Uninstalling Masterform Before you uninstallTo uninstall Masterform License Agreement Page Page Index Page Naid Page 156 East Pine Street, Suite Seattle, WA