Twice a year, I am required to drive around our subdivision and inspect for working yard lights. If the light is out, we send a preprinted post card notification. If the light remains out after 30-days, we start a monthly fine violation which requires mailing, tracking, and follow up.
Keeping a updated lot owner address list is always a challenge. Several subdivision addresses are rentals with different owners address. Correspondence requires sending to the owner address with reference to the subdivision address violation. Follow up inspections on the non-working yard lights and maintaining those records is work. The whole process of printing address labels, keeping track of everything requires a lot of effort. The subdivision has 400 homes and we typically have 50 to 70 non-working yard light violations to contend with.
I would like to find an off the shelf solution that would manage inspection record keeping and mailings. Seems like it might be a Microsoft Access application however that would have to be developed. Looking for suggestions.