These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Tuesday, April 12, 2016

Steve Washenko: Automating Studio Emails

Executive Summary

My wife, Shirley, has been teaching piano for almost fifteen years. It has only been the last four years that she has asked me to help with billing her students. This includes figuring out how much each student owes, keeping a ledger of the balance due for each student, and sending out emails to students parents reminding them of the amount due for the coming month. Shirley’s studio has ranged anywhere from 15-30 students. Sending emails to each of the parents became a very tedious and time consuming process. Automating the process and making it such that special messages could be included if desired became a very attractive task. I estimate that by automating the email process I will save approximately 30 minutes each month.

No comments:

Post a Comment

Blog Archive