Executive Summary
The Business
The Graduate Supply Chain Management Association (GSCMA) has
a rafting trip every year after orientation for the first year students as a
team building activity. As vice
president of the GSCMA, it is my responsibility to plan the rafting trip.
The Problem
Each first year student needs to receive a personalized
email inviting him or her on the trip.
The student then needs to be able to register for the trip. The registration must then be processed and
information obtained from that registration, such as camping gear inventory and
food restrictions and allergies, must be in a usable format in order to ensure
both the comfort and safety of each participant.
The Solution
This VBA project automates sending a personalized email with
registration survey link to each student.
Once participants have taken the survey in a Google Form, the
information is automated by the push of a button from a Google spreadsheet into
the excel workbook. The spreadsheet then
gathers, cleans, and sorts the data into a digestible format. The information is displayed in a
registration form so that the spreadsheet administrator can easily update the
information. The project also ensures
that duplicate emails are not sent and updated data is not written over by new data
imports from the registration survey.
No comments:
Post a Comment