* * * ZipMail * * *
This program should prove useful in automating your
mailing list. It has a number of key features not
available in other programs. The obvious features are
not described here, but there is screen help where
Please address all corespondence to:
Jack E. Lohman
266 E. Nob Hill Drive
Colgate, WI 53017
I can also be reached on Bob Mahoney's BBS at: 414-964-5160
Please note that the following files are useful to the
program, although not mandatory. If used, they will need
to be in your DOS path.
STRIP.COM Strips Wordstar characters, making
the duplicate file pure ASCII.
LIST.COM For reviewing files on the screen
STYPE.COM " " " " " "
All of the above can be found on Exec-PC
Note that ZipMail has its own "lister" and is faster than
the others because it doesn't have to be swapped out of
memory. Unless you need the "FIND" and other features of
LIST.COM, I would stick with the internal feature.
As a point of interest, the screens were generated using
SAYWHAT!, an excellent program which is available through:
The Research Group
100 Valley Drive
Bisbane, CA 94005
Also, SAYWHAT!'s VIDPOP ** must be ** loaded before starting.
You can put it in your autoexec, or use MARK/RELEASE to MARK
memory before running ZipMail and RELEASE it afterwords.
Note that the original database has 3 names in it for practice.
You can delete these after you are ready to go with your own.
Simply "Set" to NOTES and search on "sample".
ZipMail setup: Create a directory called ZIPMAIL. This will store all
PRG's, DBF structures, FMT's, BIN's, and etc.. Create
subdirectories for your own data. This can be done
automatically within ZipMail using the UTILITIES "N"
root \zipmail \zipmail\clients
\zipmail directory will house ALL programs, files,
and the structures of all DBF's. PATHES.DBF can
only be found here, and will contain all GLOBAL data
common to the system.
\other directories will be created in UTILS ames
setup mode. When a new directory is dited into the
system, a new set of file structures will be copied
to the freshly made directory. Each subdirectory will
SYSTEM.DBF All of these files will contain data
NAMES.DBF common to this directory. If you
PRINTER.DBF use a file utility to find/delete
NAMESTAT.DBF duplicate files on your hard drive,
CODELIST.DBF make certain that you do not delete
CODES.DBF any of these, as the filenames will
appear in all directories found in
pathes.dbf (yet the file sizes will
vary from directory to directory).
You can have as many different directories as you wish,
but only (8) may reside in ZipMail (PATHES.DBF) at any
To start the program: (after loading contents to \zipmail directory
just type ZIPMAIL (or include it in a batch file).
Updates: If you set up your directory structure per the above,
and **your** NAMES.DBF's do not reside in the \zipmail
Unzip the latest version to the \zipmail directory
and. While unzipping, say "yes" to all overwrite
requests. I will never overwrite the PATHES.DBF,
but may periodically change its structure via the
automatic update procedure. All other DBF's and STR's
in the zip file are needed if structures are changed.
If your NAMES.DBF file **does** reside in the \zipmail
directory, change it per the above. Copy all DBF's
(except PATHES) to \zipmail\yourdir, unzip the latest
ZipMail file into \zipmail, use ZIPMAIL's UTILITIES "N"
mode to set up the appropriate directories,
Delete all IDX's (they will be recreated) and hit
Ignore on all errors.
Mono Screens: If poor results are seen with the current screens, try
copy foxpop.bin toshiba.cpu
(just makes a dummy filename,
and forces use of toshiba.lib)
If that doesn't work well:
then: delete toshiba.cpu
set MONO in UTILS/SYSTEM
The use of mono displays with color cards makes this a
Reserved CODES: ZipMail allows two types of codes to be used:
SEARCH (SRCH) codes identify the "type" of person the
record contains (i.e., Client, Prospect, Doctor, etc..)
SRCH codes are unique to each record. They are needed
only if you wish to differentiate between record. No
SRCH code in a record means that it will print only
when no SRCH code is selected. You can define up to 36
codes (in Utilities/Codes section), and use any
combination in the screen/print modes.
Note also that two codes are reserved in the SRCH
field. The program always considers a "C" in srch to
mean CUSTOMER and "X" to mean COMPETITOR's clients.
If this doesn't suit your application, you can alter
the PRG accordingly.
MAIL codes are unique to each mailing, but do not have
to be used if you don't want them. They allow you to
insert a code in each NOTES field as you are printing
labels/letters. If you insert "abc" for a list of
labels, you may subsequently use that PREVIOUS CODE to
create personalized letters to the same group, or
another set of labels as a followup to the first set.
If you used "abc" for a limited set of labels (i.e., by
zip code or SRCH code, you can then do a second, broader
mailing (i.e., by state) and the program automatically
excludes every record that has an "abc" in it.
Keep your codes as brief as you can and keep a
cross-reference list so you can identify them later.
Readme.doc Is not kept up very regularly. Features may exist that
are not listed here, but are documented with on-screen
* * * Menu #1 * * *
-- Records -- -- Printing --
a) ADD l) LABEL printing
d) DELETE p) PRINT lists
r) Rapid Review m) Misc
-- Files -- u) Utilities
i) INDEX records s) SHELL to DOS
v) VIEW list c) CHANGE index default
2-9 Selects Database
1 Shows list
* * * Menu #2 * * *
d) DELETE codes from notes field p) PACK after purging of
(accidental mailings) duplicate names (after
"screen purge" only")
l) LIST mailings done to date
r) REVIEW codes (selective)
c) COUNT codes
k) STATE counts
i) IMPORT Wordstar Files
m) MAIL/MERGE of form letter
(requires entry of letter) s) SHELL to DOS
* * Adding Records * *
First + Initial
State Address by:
Zip a Mr, Mrs, Miss
b Mr. & Mrs.
Area code Phone c First Name
1) Fresh Screen 2) Constant Address 3) Constant City Mode
* ADD menu: A "1" as the first and only character in the last name field
will cause the system to provide a fresh screen for each name.
A "2" will provide a constant address for multiple people
at the same address. Changing the address changes all
subsequent entries. A "3" is for constant city.
The current mode is displayed at the bottom right screen.
You may switch gears as often as you like.
If you select "Address by first name", a default is offered.
* DELETE menu: Allows you to select individually by name or record number.
prints potential duplicates and their record numbers.
offers an interesting interactive method of deleting.
DELETE NAMES BY:
i) Individual name
n) Record number
p) Print duplicates
s) Screen purge
If this is a selective mailing, enter to whom:
RN = by Record Number
DH = by Department Head
XC = All eXcept Clients
PC = to a Previous mailing Code
IC = Include COMPETITOR's clients
BR = Brief Report
= Passes to next screen
* The LABELS and MAIL/MERGE features allow you to select mailings by:
RN - record number selections can be entered.
DH - allows entry of a department head, but note that because
many mailings may go to the same address but different
department heads, the "mailing code" selection is disabled.
XC - assumes that you use "c" as your customer "search" code.
PC - lets you send followup letters to previous mailings, as long
as a code was appended in the earlier mailing.
IC - Exclude competitor's clients is the default.
* In addition, you can use any of the following "Search" codes.
(see: Utilities, Code). These can be altered to fit your own needs.
a This is a sample code s
c Customers u
d Dealers v
f x Competitor's Clients
g General Practice Physicians y
i Internal Medicine Physicians 1
j 2 Selected Physicians
k Key Names 3
What code do you wish for this mailing?
(Program will exclude those
with this code already in record.)
* For each mailing, you can include a "mailing" code which will be
inserted into the NOTES field. If you use that code on a
subsequent mailing, those receiving the first mailing will
not receive the second mailing. This can be circumvented
by using a new code each time, or no code at all.
- The codes can be a combination of upper/lower/numerics
which allows unlimited combinations.
- Keep the code lengths to a minimum to avoid premature filling of
the notes field (you can expand it with MODIFY STRUCTURE).
- If you want to remove a mailing code (so it can be reused for
a new mailing), at the miscellaneous menu #2 will do.
- At this same menu, will list the codes used to date.
- All mailing codes are automatically deliniated with a "," in the
Note: "Search" codes are unique to each record in the database. They
can be only one character long. "Mailing" codes are unique to
each mailing, and although they can be longer should be kept to
under 5 or so characters to avoid filling the notes fields.
If you want ALL records, just hit .
Otherwise, you may enter just one code,
or any combination of codes, providing
each code is separated by a comma, "plus"
sign (+), or parentheses "()".
A comma means "OR", a plus means "AND".
A string of codes may be either AND/OR
A,B,C = (A or B or C)
X+Y+Z = (X and Y and Z)
A formula might look like: (A,G,K,M) + (S+X)
For best results, place OR's in one set of
parentheses and each separated by a comma (,).
Place AND's in a different set of parentheses
and separate each by a plus sign (+). ? = Help
* You can select the mailings by virtually any combination
of AND or OR arguments, providing you have creatively
devised a good scheme of keeping track of them. A sample
CODE database is enclosed.
* The program should catch most, if not all, errors in the formula.
However, what you "think" is a correct formula may not be how
Foxbase handles it. You might want to run a trail using blank
paper or try the formula in the "Print List" or "Review" modes.
* Label setup screen
You may set up your system for just one label type (1up - 4up).
Enter how many labels across (1-4): (1 for envelopes)
Enter the horizontal column numbers of each label.
> Enter the number of printer lines between rows 1 & 2.
The system only prints labels at 6 lines per inch.
Thus, if the distance is:
1.00 inches, page length must be 6 lines,
1.50 inches, page length must be 9 lines, etc.
* Only the 1st label setting is used for Envelopes (1 up)
Lines per label:
* * * Mail/Merge * * *
Enter the filename
Enter file path
Start printing at line:
Set left margin at:
irectory dit ist eit
* Mail/Merge screen:
Quiet to Screen shuts console off during printing
except provides a continuous count to let you know
where you are.
Edit calls up MODIFY SCREEN or any other Editor
indicated in the system setup. Note that Foxbase
requires a lot of memory by itself, so there is not
much left over for a memory guzzler editor. Pick
one that uses little memory and allows calling the
document from the command line.
LISTOR is Buerg's LIST.COM or similar.
* Mailing labels can be generated using standard Avery labels
3.5" x 15/16" One across. (Avery #4013 is 5000 per box).
* 4-across mailing labels can be printed if you have a wide
carriage. Make sure you set the 4-up flag in the SYSTEM
* You can also print lists with one name per line and in a
variety of formats.
* "COUNT codes" allows you to count the number of mailing pieces
needed for a particular set of conditions.
* Remember that two codes are reserved in the SRCH field.
The program always considers a "C" in srch to mean CUSTOMER
and "X" to mean COMPETITOR's client. If this doesn't suit your
application, you will have to alter the PRG accordingly.
In case of trouble:
* If ever in doubt, INDEX the records (main menu).