Gooru Tip - Maximize the video player and adjust video quality for optimal viewing!
Here’s my quick guide on creating a simple mail merge using Google Apps Script and Google Forms. Certainly a lot of use-cases for this one! Just imagine what you can do.
While there’s a big difference in replicating this video and actually understanding how the Google Apps Script piece of the equation works, it’s not too hard to simply copy the spreadsheet template provided and mess around a little bit. Don’t forget to change the maxRows value when you add new fields to your form!
Here’s the blog post I refer to in the video -http://googleappsdeveloper.blogspot.com/2011/10/4-ways-to-do-mail-merge-using…
What are your favorite uses for this feature? Let me know in the comments!
This is brilliant! It is so easy its stupid! We’ve been looking for a mail merge solution ever since we went google, it’s a big missing thing that keeps some of our users clinging to outlook. Thanks for the video, it’s very clear.
Looks like the Yet Another Mail Merge script has busted in the last week. It now throws an error – Script function startingPageforStandardMerge could not be found. Is this really the only script around to run a mail merge on Google Drive!! I’d be very happy for other suggestions…
In your video you manually change the last parameter on the getRange method from a 4 to a 5 (to reflect the new number of columns). Why not grab the last column dynamically?
line 4 of the script goes from
var dataRange = dataSheet.getRange(2, 1, dataSheet.getMaxRows() – 1, 4);
to
var dataRange = dataSheet.getRange(2, 1, dataSheet.getMaxRows() – 1, dataSheet.getLastColumn());