Lexmark Version 3.0 User Manual

69

    68

Import Excel or Access address

data to the Address Book

If you have addresses in an Excel or Access table,

you can import them into the MASTERFORM

Address Book database found in C:\MF_UPS\

Exchange.mdb > Tables > upsAddress.

The MASTERFORM address book is controlled by

the Microsoft Access 97 database named

Exchange.mdb. The table that stores address

data is named upsAddress and it is configured

with the following column names. This is what the

columns in your Excel or Access file must match,

in this order:

CompanyName, Address, City, State, Postal Code,

Contact, Phone

(a) Make a copy of your current address database

or Excel table and work off the copy.

(b) On the copy of your address database/table,

modify your data so that MASTERFORM can

accept it: rename your column headings to

match those listed here exactly and delete

any other columns. MASTERFORM will only

accept these columns. For example, an Excel

sheet ready to be imported will be formatted

as shown in Figure 20.

(c) When your addresses are ready to be

imported, open the MASTERFORM database

that stores address data: Exchange.mdb.

To select an address, search for the name or

browse the letter groupings. When you find the

address you want, highlight the name by clicking
once anywhere within the entry. Then click

Select. The address will be pulled into your

template.

Figure 19: Find the address you want, highlight by clicking
once on the name, then click Select.

To edit an address, highlight it and click Edit. To

delete an address, highlight it and click Delete.