Alternative Vendor Mailings
Shop-Pro prints mailing labels for vendors for small-scale mailings;
one-across and usually one at a time.
If you want to do a mass mailing you could export the vendor list to
a Microsoft Excel file or a Comma Separated Values (text) file and then complete the mailing from your word processor such as MS-Word.
From Shop-Pro choose File, Misc, Dot-Prompt.
At the blank screen type these lines with Enter after each line
(note the underscore after ZZ and after VEN and the quotes and
the \ backslash.
USE VENDORS INDEX VEN_NAME
SET FILTER TO RECNO() > 1
COPY TO (ZZ_RPTFOLD+"\VENDORS.CSV") TYPE DELIM
COPY TO (ZZ_RPTFOLD+"\VENDORS.XLS") TYPE XLS
This creates two export files located in the JSREPORT folder on the
The first is called vendors.xls and is an MS Excel file. You can read
the first in MS Excel or may MS-Word
The second is called vendors.csv and is a comma-delimited text file
that you can read it in MS-Word or other programs.