Lexmark Version 3.0 manual Exporting addresses from the Address Book

Page 38

(e)Click Next to continue.

(f)Confirm that the Import to Table field reads “upsAddress,”then click Finish. Access will pull your data into MASTERFORM for UPS. Open MASTERFORM and make sure your address data is there.

If you encounter any errors during the import process, double-check your steps. Make sure the upsAddress table is not open and your columns are named correctly, then try again.

Exporting addresses from the Address Book

You can easily export the address data used in MASTERFORM for UPS to a new Excel file or Access database. MASTERFORM stores addresses inside the database named Exchange.mdb, which sits in the install directory (C:\MF_UPS by default).

To export addresses from MASTERFORM:

1.Open Exchange.mdb in Microsoft Access 97 or 2000.

2.Highlight the table upsAddress by clicking once.

3.Choose Save As/Export from the File menu.

Figure 25: Choose Save As/Export from the File menu inside Microsoft Access.

74

75

Image 38
Contents User’s Guide User’s Guide East Pine Street, Suite Seattle, WA Toll free Local FaxContents Getting Started Using Printing the Shipper’s Installation and Setup General features Introduction to MasterformProfessional and Military Edition Suites Installing Masterform for UPS Domestic EditionDownload New UPS Chemical Table feature Domestic or International? What’s my name & password?Structure of Masterform New shipping paper design for laser printers Where to install MasterformWhere to get forms To manually set up the System DSN connection Install the softwareSet up the System DSN connection Sending your Masterform shipments to UPS OnLine WorldShipHazmat Confirm that Hazmat is now listed, then click OK To specify a hazmat package in WorldShip Send hazmat shipping paper data to WorldShipSpecify a hazmat package in WorldShip Deleting HAZMAT/DG recordsSupport and Resources Via E-mail Technical Support and Contact InformationBy Phone Online InfoLabelmaster Software Hardware Recommendations Other ContactsDOT Contact Chemical table resources RememberAddresses Managing Templates and AddressesTemplates File ExtensionsMasterform Masterform Setup Setup AccountsPackage Label Warning Bypass Authorization ScreenSave template by default Allow Proper Shipping Name editsShipping under multiple accounts Security Defining user names and passwords To add users to the listWhy are my log book numbers repeating? How log book numbers workMaking, naming, and saving templates To Save a TemplateWhat should I name my template? What is a template?When should I use templates? How do I reenter a saved template?Working with templates To select the Edit PSN option Deleting templatesEditing the proper shipping name PSN Using an Exemption Packaging number Confirming the labels required for your packageTurning off the Labels Required field warning Pre-printing forms for future useFeatures and Options To read a note Writing notes insideTo write a note Entering addresses in the Address Book Import Excel or Access address data to the Address Book Prepare your dataImport your data into the upsAddress table Format your address data into columns with these exact namesSelect Get External Data Import from the File menu Exporting addresses from the Address Book To export addresses from MasterformSelect how you want to save the table To remove a default field value Setting default field valuesTo set a default field value Saving multiple field valuesViewing the regulations Form-Fill Wizard Step by Step Screen 1 Shipment Template Choose a template and a form type to beginScreen 4 Proper Shipping Name Screen 2 Shipper InformationScreen 3 Shipment Information Screen 5 The Chemical Table Quantity and Unit of Measure UOM Limitations Screen 6 Ground or Air ShipmentScreen 7 Print Preview Add up to three materialsScreen 8 Print and Save Shipment Template Print Preview you canPrinting the Hazardous Materials Shipping Paper Form 2 Shipper’s Certification General Printing OverviewForm 1 Hazmat Shipping Paper PrintersInstalling a printer Creating a custom paper size tractor67 in 800 To manually create a custom paper size Windows 95Select the option Use Specific Printer To manually create a custom paper size Windows NTChanging the printer driver Suggested printer driversChanging the Emulation Mode on the printer tractor To change to the Epson driverIf you are using the tractor form Setting the MarginsTo change the Emulation Mode on an Okidata 320/321 If you are using the new laser formMoving fields on the form use the Nudge tool Nudge toolTo use the Nudge tool Increase or decrease the size of printed text Add or remove lines from the printed formPrinting the Shipper’s Certification Printing the certification To print a Shipper’s CertificationSave to Shipper’s Certification? Saving shipments to the certificationRemoving mistakes or duplicates from the certification Purge old certification records Click Purge DataTroubleshooting Overview Printing gibberish or symbols Account number not in the drop-down listShipper’s Certification prints on two pages Custom paper size not in paper size listPrinter feeds forms up too far Printer prints blank pages Laser forms are not lining up properlyText you entered isn’t an item on the list Log book numbers are repeatingCan’t edit the PSN proper shipping name UPS WorldShip, the HAZMAT/DG Reference list is grayed out UPS WorldShip, the HAZMAT/DG Reference list is blankUnexpected 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 To uninstall Masterform Uninstalling MasterformBefore you uninstall License Agreement Page Page Index Page Naid Page 156 East Pine Street, Suite Seattle, WA