SHOPKEEPER > CUSTOMER LIST

MAILOUT.V92

How to Send a Customer List to a Mailing House

(For Version 9 up to Version 9.2)

The following instructions will put a copy of the mailing list on a

diskette that you can give to a mailing house for them to send out a

mailing. The file is an ASCII file with each field delimited with

quote marks and separated with comma's. The first line in the file

defines the order of the fields and any proficient mailing house will

be able to read this file. Note: This is NOT designed for the mailing

house to send mailing list corrections back into the Jewelry

Shopkeeper.

From the Main Menu, choose Reports then Customer Mailing Labels.

Choose any combination of criteria such as Zip Code, Customer Type,

etc. At the very least it is useful to restrict the Zip Code range to

01000->99999 to ignore those customers with no zip code. If you have

version 8.7 or higher, you can choose the for Total Purchases option,

making sure you choose Yes to recalculate.

Choose Start Printing Labels, choose the Sort method you want (Zip

Code or Last Name) When you are prompted to choose 1, 3 or 4 across

labels, choose instead the \MERGE1.JS option. This sends the results

to a file on the hard drive called \MERGE1.JS (in the root directory)

When this has finished, exit the Jewelry Shopkeeper and go to the

COMMAND MENU.

IMPORTANT NOTE: If you don't automatically go to the COMMAND MENU when

you exit the Jewelry Shopkeeper, go to the DOS prompt for the drive

where the Jewelry Shopkeeper is installed and type JS and press Enter.

(or, if you have Windows 95/98/98, you can click on the JS-MENU icon.)

At the COMMAND MENU, you can view the contents of the file by typing:

VIEW C:\MERGE1.JS

To copy the file to a diskette, go to the COMMAND MENU, insert a blank

(formatted) diskette into the A: drive (or substitute B: below for the

B: drive) and type these two lines: (pressing Enter after each line)

COPY PKUNZIP.EXE A:

(this may respond with "1 file(s) copied")

PKZIP -a A:CUSTLIST C:\MERGE1.JS

Where -a is a dash follwed by a lower-case A. After this has

finished, it will show you the percentage by which it compressed the

customer file þ something like (75%), done (where 75% indicates the

amount the file was compressed).

To return to Windows, type EXIT and press Enter.

*************************************************************

After you copy the mailing list to a diskette per the above

instructions, if you want to double-check the names that got put on

the disk follow these steps:

Go to the COMMAND MENU or a DOS prompt and type these lines,

pressing the Enter key after each line:

MD C:\TEMPJS (it's ok if you get Directory Already Exists)

DEL C:\TEMPJS\MERGE1.JS (it's ok if you get File not Found)

A:PKUNZIP A:CUSTLIST C:\TEMPJS

EDIT C:\TEMPJS\MERGE1.JS

Note that when you are in the (usually blue) EDIT screen there is a line

counter at the bottom right corner so you can count how many lines/names

are in your file. You can go to the bottom line by pressing Ctrl-End to

quickly get the line count.