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
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
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:
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
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.