PDA

View Full Version : Gmail Mail Merge: Editing Script



Noah_Kaplan
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.

Thanks,
Noah

IT4SmallBiz
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.

See

http://www.it4smallbusiness.co.uk/web-applications/google-mailmerge

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

IT4SmallBiz
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).

IT4SmallBiz
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.