How to Send a Customer List to a Mailing House
(for Shop-Pro Versions up to Version 8.7)
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 commas. 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
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
black and white COMMAND MENU.
IMPORTANT NOTE: If you don't have a Windows JS-MENU to take you to
the COMMAND MENU, go to the DOS prompt for the drive where the Jewelry
Shopkeeper is installed and type JS and press Enter.
At the COMMAND MENU, you can view the contents of the file by typing:
Once you have made the file you can either attach the file to an e-mail
message that you send to the mail-house or you can mail a disk them.
If you e-mail the file note that file to be attached is in the root of
the drive where the shop-pro is installed. Or see below on how to get
the list to a diskette.
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 \MERGE1.JS
Where -a is a dash followed 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 this responds FILE NOT FOUND)
A:PKUNZIP A:CUSTLIST C:\TEMPJS
(to go to the end of the file, press Ctrl-End. You should see a line-
counter at the bottom right corner. This can help you verify that the
number of customers is approximately correct)