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

Thursday, December 8, 2011

MIRACLES (MIssion Reunion Automated Contact List of Elders & Sisters)

Every year, mission presidents sponsor mission reunions to see their beloved elders and sisters. Although we live in the social media era, we are still in the lone and dreary world. It's a pain for mission presidents keep in touch with every elder and sister and get them invited to mission reunions. Mission.net is a non-Church sponsored website that links all missions websites. Most elders and sisters are listed and get their profile updated on a regular basis. However, due to spam protection, it's not easy to pull data from in there.

So, MIRACLES (MIssion Reunion Automated Contact List of Elders & Sisters) is a macro-enabled Excel sheet that automatically pulls data from Mission.net website, organizes into a spreadsheet, sends out mission reunion invitation and enables an RSVP follow-up. Additionally, the guest list is synced to a GoogleDoc, allowing visibility for those who received the mission reunion invitation. After having had a hard time on a mission, now it's time for you to enjoy your old folks. Believe me, it's a "miracle" what this tool can do for you.

http://files.gove.net/shares/files/11w/tlima/MIRACLES_Trajano_Lima.xlsm
http://files.gove.net/shares/files/11w/tlima/MIRACLES_TrajanoLima.pdf

No comments:

Post a Comment

Blog Archive