Sales Database Linked to Mass Email Generator

2006-2011 – Created a 5,000 item prospect database through hand data entry.  This project centralized hard copy lists collected from various sources over the previous several years.

The database was linked with a locally-installed HTML email generation program.  This allowed efficient fulfillment of mass email prospect and client communications.

Appropriate categories were created with associated queries.  Existing Clients who had purchased various products were coded so they could be brought up in various combination for mailings and solicitation of other products.  Sales prospects were coded by their position in the pipeline.  In this fashion people closest to buying were given appropriate priority treatment with little effort.

After initial creation maintenance was performed.   New records were added, existing records were updated, and records of contacts who requested no further communication were removed.