Navigation:  SHOPKEEPER > VENDORS >

VENXLS.V97

Previous pageReturn to chapter overviewNext page

VENXLS.V97

 

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

QUIT

 

This creates two export files located in the JSREPORT folder on the

Windows desktop:

 

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.