<div>
A further thought .... It would be even easier to design your Access database to just print Mailing labels.
</div>


<div>
All the yard lights require a working photo electric switch to provide dusk to dawn operation. &nbsp; We typically drive around the neighborhood well after dusk which makes it obvious when a light is non-functional.<br />
<br />
We have found leaving a notice at the door has its problems. &nbsp; Notices need to be addressed to the dwelling owner. &nbsp;People to rent simply ignore the notices. &nbsp; Owners are subject to fines.<br />
<br />
Eirman, I like your idea about using the database. &nbsp; Provided we can create a method of quickly locating the approperate database record as we drive along, seems like using an Access database to print mail labels might just be the solution. &nbsp; Last inspection yielded 85 outages.
</div>


<div>
Using a database to track outages and print mailing labels for postcard notifications or provide data to an outsource mailing service seems like a viable solution.
</div>


<div>
<blockquote>
All the yard lights require a working photo electric switch to provide dusk to dawn operation.
</blockquote>
I should thought of that possibility.<br />
<br />
I would use a rough map of each street and put an X against each offending property during the drive around.<br />
Then back at the office. it should be easy enough to mark the appropriate properties in the database.<br />
<br />
Thanks for the points.
</div>


<div>
<div class="content wysiwyg-content">
Yard lights in our subdivision are the only means of illumination and residents are required by the covenants to keep working. &nbsp; &nbsp;As chairman of the architectural committee, one of my volunteer efforts includes driving around twice a year and record any address with a non-working light. &nbsp; Next step is to associate those addresses with a name on our membership list. &nbsp;Once that is completed, the list (excel spreadsheet) is uploaded to a service who mails a postcard to each address. &nbsp; With 435 potential addresses, this is a semi-annual burden.<br />
<br />
With all the modern technology and Experts available, I am confident there must be a way to help automate this project.
</div>
</div>


Yard lights in our subdivision are the only means of illumination and residents are required by the covenants to keep working.    As chairman of the architectural committee, one of my volunteer efforts includes driving around twice a year and record any address with a non-working light.   Next step is to associate those addresses with a name on our membership list.  Once that is completed, the list (excel spreadsheet) is uploaded to a service who mails a postcard to each address.   With 435 potential addresses, this is a semi-annual burden.

With all the modern technology and Experts available, I am confident there must be a way to help automate this project.

SUBDIVISION YARD LIGHT IS OUT, YOU NEED TO FIX IT

Personal electronics includes any device, including fitness and health trackers, watches and wearable technology or personal GPS devices. Examples of these devices include the iPad, iPhone, Cell Phones, Smartphones, BlackBerry Hardware, Digital Cameras/Camcorders, Home Theaters, Home Security systems, Game Consoles, Wireless Hardware and Automotive systems.

Personal Electronics

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

A consultant is a professional who provides professional or expert advice in a particular area such as security (electronic or physical), management, education, accountancy, law, human resources, marketing and public relations, finance, engineering, science or any of many other specialized fields.