The other week we decided to send out a mass email to our cheerleading team in order to get information from each cheerleader. The problem was that we didn’t want to send sizing data about other cheerleaders. This meant a custom written emails for each cheerleader. We had an excel spreadsheet, I exported it to CSV and then wrote a ruby parser to generate custom email files for each cheerleader.

There is some room for improvement:

  • Parameterize the inputs. Pass in the CSV, destination folder, a template file
  • Use a template file for emails. Instead of manually including the message