View Full Version : Gmail Mail Merge: Editing Script

05-25-2010, 06:39 PM
I'm trying to setup a mail merge using a gmail docs script from http://www.labnol.org/software/mail-merge-with-gmail/13289/. So far, it works pretty well, but I want to edit it to include the following:

1) The script should start with "Dear Noah" as opposed to "Dear Noah Kaplan" (Gmail contacts are entered into just one field, so in order to do this, one would have to edit the script to negate anything after the space between the first and last name).
2) I want to add my canned response logo signature so that appears at the bottom of the e-mail.
3) Allow the text in my logo signature to be selectable and for the links to be clickable. How can I do this?
4) For my logo signature to be a CSV file.

Any help would be much appreciated.


05-11-2011, 02:17 PM
If you're looking for a script for mail merging Gmail and Google docs, we've created one which works similarly to a Microsoft mail merge.



The sheets and script are free to use/copy/modify.

08-31-2011, 11:05 AM
We've now updated the script mentioned in our previous post, so it handles up to 100 emails in one go (or at least, it does in our testing - the exact number is set by Google as an anti-spam measure, who don't disclose the details).

01-13-2012, 04:05 PM
Just to add, we've recently (January 2012) updated the script so you can use mailmerge fields in the email subject. If you've already made a copy, you'll need to make a new copy to get the new features.