Mail Merge Using Google Script to send customized mails to multiple contacts

Hey there,

Almost all of us must have been in a situation in office where we had to send bulk mails as a personalized mail to each client with their name (E.G : Dear Roshan Pillai,). Normally we would have to send such mails one by one to each client, other option includes purchasing a mass mailing software which could be costly, third option is using mail merge. But usually you cannot send more than 100 emails using mail merge on your company’s email id as there are mailing limits. So what would you do in such a situation???

I can help you make your work life a bit easier by using Google Scripts. No, you do not need any programming experience to accomplish this as it is already coded and ready to use, its based on a code by Amit Agarwal of Digital Inspiration. It works on Google docs platform and uses Google spreadsheet as a Data Base and you can send 500 mails a day using this!!!. I have modified the code a bit.

You can access this app through this link :

https://docs.google.com/spreadsheet/ccc?key=0AoTA_FwF4KGAdENDaVhmZ0ZQM05JQ05ZMTBqVDlrS2c#gid=0

I have given full access to the app, so you can create a copy and use/modify it as per your need.

Here is a screen shot of the page :

Image

Once your enter the recipient name and email address, fill in the senders info and message body. Once done, click on ‘mail merge’ option on top and then click on ‘start mail merge’, it will send the mails to the email addresses you entered. It also shows the status of mails next to the email address. If it was sent successfully it will display ‘OK’.

You can also import your Google contacts if you wish to!.

So go ahead and try it, and let me know if you have any queries.

Love,
Rosh

Advertisements
Posted in Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: