Posts Tagged mail merge

Mail Merge in Gmail With Attachment Support

The post and spreadsheet provided by Amit Agarwal on How to Create a Mail Merge with Gmail and Google Docs is extremely useful.  But for last few days, I have been wanting to send attachments along with the mail merge. I tried many options but was unsuccessful, finally a set of combinations worked for me and I am sharing that spreadsheet so others don’t have to go through the same trouble.

Follow the above provided link for understanding how to use Google Docs for mail merge, after that is working fine, you can use the following spreadsheet. This is the spreadsheet which can be used to add attachments to email. I have an editable column F13 where you will have to provide Document ID. Once you provide the document id, the steps to send emails are exactly same as mentioned by above blog post.

How to get Document ID:

Step 1: Upload the document that you want to attach on Google Docs.

Step 2: While uploading the document make sure that the option ‘Convert documents, presentations, spreadsheets, and drawings to the corresponding Google Docs formats’ is checked. If you do not check this option, your documents will not attach properly.

Step 3: Open the document and go to the URL. You can to use the id value as document id. Example: If URL is

https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B_7_CbUovM_8YWJhYmQxNjktOTdiNS00ZWMyLTg3MzEtNGE3MWVhMjQyYTc4&hl=en

then the characters in bold are document id. Copy and paste them into the F13 box. When you send the mail, document with id will be attached.

I have added another feature of getting the remaining mail count of the day. That can also be accessed from the menu and count is shown above on the spreadsheet.

Update: I have updated the script to provide multiple attachments. Now columns F13 to F17 can contain different attachment IDs, or can be left blank.

, ,

27 Comments