Closed
I recently had 600 people needing various trainings in my district and training in two weeks. In order to email them their individual list of trainings needed I would have had to look up each of them in ScoutNET and write an email one at a time.
Luckily, I'm a little smarter than that. I found software on the Internet for $30 that merges the Training spreadsheet with columns from the membership roster spreadsheet (I needed email address) by matching the BSA ID# from both. This gave me a training spreadsheet with email address. By splitting the courses column into 3 columns and doing lots of search and replace I was able make a human-readable spreadsheet which I then did mail merge and sent each individual the list of trainings they needed by email with the click of a button.
I've created a web application that merges the two spreadsheets for free and does all the search and replacing at http://ironhorsebsa.org/tools/training . Can't National improve ScoutNET to make it more usable with email by at least including the email address?
See my Facebook post in the BSA Professionals group at http://www.facebook.com/topic.php?uid=7506061819&topic=7102 for more details
Revise
Post New Comment
Completed
In Progress
Pending Moderator Approval
Close