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.
https://gist.github.com/2568583.js
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