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

Wednesday, April 11, 2012

Automatic Email Generator for HR Recruiters

Executive Summary

When students attend job conferences or fairs (like the National Black MBA Conference [NBMBA] or the National Society of Hispanic MBA Conference [NSHMBA]), organizations collect a lot of student business cards and/or contact information for perspective job candidates. The program I’ve created is for a recruiter (in this case, a recruiter for General Mills) to gather names of potential job and internship candidates for various marketing positions within the organization. Then, with a click of a button, the recruiter can send an automatically generated customized email to each candidate letting them know the status of their application or interest with the company, based on the inputs the recruiter provides.

Additionally, I created a tab that contains a chart that is seamlessly updated with the count of the types of emails that have been entered into the spreadsheet via the User Form. This helps the recruiter to track candidates so that the marketing department does not accept or reject too many candidates.

I wanted to make this spreadsheet extremely user friendly as many HR professionals are not known for the Excel skills and I wanted it to be as intuitive as possible. I know that by automating the email process, a recruiter can save a lot of time by not having to manually change a form email for every candidate.

No comments:

Post a Comment

Blog Archive