I work with a non-profit organization. We have an Access database of donors over the years, and records of each donation received from each donor. Currently, as we receive each donation the staff updates the database to record the donation, and then manually prepares a "thank you" letter to the donor in MS Word. They have ten different letter templates they fill in based upon the type of donation.
I need the Access database modified to automate the production of these letters. Basically, the staff would enter the new record of the donation, and then click a button on the record to produce one of the pre-formatted letters (that I will send you) with the data (name, address, amount, etc) filled in from the donation record. The letter needs to be formatted to fit our letterhead. Finally, some donations are from businesses and some are from individuals. The grammar and structure of the letter is slightly different for an individual versus a business, and this would need to be accounted for. The donor records do not differentiate between the two, and it would be fine if the staff picked as part of producing the letter.
Additionally, the staff needs to be able to select some of the donors in the database and produce a batch of envelopes printed with the donor's address (from the database) to mail these letters. The envelopes would be done in a batch after several letters are produced since they have to go change letterhead to envelopes.
Finally, the general content of the pre-formatted letters changes periodically to reflect the name of a production or campaign, so the staff would need to be able to update the letter templates on the fly.