Previous pageReturn to chapter overviewNext page



       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)



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




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)



(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)