Re: Send email from Google Spreadsheet

[Eddy Parkinson]

I would add a formula to the spreadsheet =if(isblank(A1), "Dear "&B1, "Dear 
"&A1&" and "&B1)


Or , Stackoverflow has a few examples: 

http://stackoverflow.com/questions/11025491/google-apps-script-send-email-based-on-date-in-cell/11025972#11025972