Mailing List System Features and Objectives:
The primary objective of the Mailing List System (ML System) by Legler Systems
is to process name and address information in an online environment, so specific
online procedures are performed in seconds rather than the hours required
for traditional batch methods of computer processing. This ML System performs
the basic mailing list objectives by providing a complete and accurate record
of all contact transactions affecting each name and address within different
mailing lists.
Specific mailing list features and objectives of this business software
application are highlighted below:
- Maintain a separate Name Address Record on each individual and
company name in the ML System by a unique Name-ID number and List code.
- Automatic Name-ID number assignment is done when new name transaction
are added to the ML System for positive control and audit trail purposes.
This mailing list feature can be overridden by the setting of
System-Option-24 (DB03).
- Provide for up to eight user assigned Category codes to uniquely code a
group of similar names.
- Provide the flexibility to handle multiple types of mailing lists
within the database through the use of a separate List code.
- Provide an easy method of allowing the user to select names to be
printed by specifying up to five different List codes and specific
categories within a mailing list.
- Print mailing address labels in several different formats, such as
1-up, 2-up, 3-up and 4-up using either 6 or 9 lines per label.
- Provide the capability to integrate the mailing list with any
letter (created with standard text editor) where this letter is
computer printed with the name and address from a selected mailing
list. Each name receives the same letter.
- Provide auxiliary data input capability for initial file creation and the
processing of name address transactions created by other computerized
systems or separate data entry operations. Multiple name address transactions
are processed at one time by procedure ML08.
- Relate names to one another for special chain mailing lists used
in multi-level network marketing.
- Provide online inquiry capability to (1) display all data elements
on a single name and (2) display all names within a ZIP code range.
- Define an Active-Flag for each Name-ID number to prohibit online entry
of an inactive Name-ID record, yet keep that old name for historical
reporting purposes.
- Provide source document control over input name transactions to the
computer by establishing batch numbers.
- Provide the capability to create custom ML reports where the user
defines the data fields to be selected, sorted and printed (DB12).
- Provide import capability (procedure ML12) to read any PC ASCII file of
comma separated values (csv) containing name and address information
and create the import Transfer File.
Multiple name address transactions in the import Transfer File are
processed at one time by procedure ML08 to edit and add them into the
ML System. Alternatively, procedure DB18 can be used to import
a csv file containing data fields that makeup the Name Address Record.
- Provide export capability (procedure ML12) to write a PC ASCII file of
comma separated values (csv) containing name and address information.
Procedure DB18 can be used to export name address information to
a csv file for use by an external application.
- Print USPS POSTNET barcodes (optional) on mailing address labels for
5-digit, 9-digit and 11-digit (nine digits plus 2-digit delivery point)
ZIP codes on a laser printer.
- Automatically display a detail Name Address Record when
function key F7 is pressed from inquiry procedure ML06. This
mailing list objective enables the operator to quickly drill down to
more information.
- Verify the state code and ZIP code (first 3 digits) associated with
a mailing address. The Canadian province code is validated when
the ZIP code is not numeric.
- Automatic mailing Name-ID number lookup by name initials occurs whenever
the mailing name initials are entered as the Name-ID field for fast
Name-ID number lookup. The mailing name initials are manually or
automatically set in the Name Address Record when it is created to
aid in looking-up or finding a mailing Name-ID number.
For mailing Name-ID number lookup by name, enter the "#" as the Name-ID
and when prompted, enter the mailing name or telephone number.
- Support any List code defined by the user with a Code-Type of "LT"
using Code Definition Records (DB01). This mailing list objective
enables the user to define multiple mailing lists.
- Provide system options in the Company Control Record to handle
6-digit dates or 8-digit dates for data entry and reporting purposes.
- Provide the capability to search for any text entered by the user and
display matching names on the screen. Both uppercase letters and
lowercase letters are tested by procedure ML06 and procedure ML94.
- In addition to online processing, batch job processing is supported where
multiple ML report requests are entered online for later batch processing.
- Easily enter notes or comments on a specific name (ML01) when the
Trans-Code is set to "N" to automatically link to procedure DB17
(General Notes Record) in the DB System.
If other financial systems by Legler Systems are installed, then the
name and addresses stored in Customer Master Records (AR System), Vendor
Master Records (AP System), Employee Master Records (PR System), Vendor
Invoice Records (Misc. Vendor names in AP System) and Order Text Records
(Ship-To names in OE System) can be automatically reformatted and added to
the Mailing List System as Name Address Records. List codes AP, AR, PR,
MV and OE are reserved to identify these special company mailing lists.
The ML System procedures that can be run by the user are identified in the
Mailing List Menu document.
Name Address Record:
Mailing name and address information is stored in the Name Address Record.
Online procedure ML01 is used to add, change (modify), query and delete
Name Address Records. For all new name entries, the Name-ID number is
automatically assigned using a sequence number counter in the
Company Control Record (DB03). Other ML procedures read these name records to
print management reports and mailing labels.
The primary key of the Name Address Record (NAR) is the Record-Type code,
List code and Name-ID number. Five alternate keys are defined for rapid access
to different groups of NAR data.
More Information on the ML Software:
For additional information on this online Mailing List software,
e-mail Bill Legler in the SF Bay Area, California
or go to the Mailing List System main page.
Version 11.6 (2024). All rights reserved by Legler Systems Company.