That's where scripts come in. Thanks to the genius of others, there are many scripts you can use to extend the functionality of spreadsheets. The one I use is FormEmailer by +Henrique Abreu. This wonderful script makes it easy to send emails with customized messages. Check out the video below and be sure to visit the FormEmailer site!