Direct Marketing System for an IT Company
We took over a system that had been started in-house by this customer to produce mail-shots. Data had been sourced from a variety of commercial mailing lists, each of which was in a different format. The system had evolved over time and was essentially several mini mailing systems - one for each format of mailing data that had been purchased.
We designed a single database to hold the company's mailing data and then wrote import procedures to import from each mailing list. The system then produced various reports to allow the client to find and remove/merge duplicate records.
A tagging system was developed which allowed the client to generate their own tags or attributes for each record. They could then extract records based on one or more of these tags. Once the records for a particular mailshot had been selected, they were then output directly to Word, either as a fully formed mailshot letter, or as mailing labels.