Mail-Merge using Google Spreadsheet
Mail-Merge is a process where-in personalized mails can be sent in bulk.
There are a few ways to send bulk mails through Mail-Merge.
- Using Microsoft Outlook
- Using Google Spreadsheet
The objective of this blog is to describe the process, pros & cons of Google mail-merge using ‘Yet another mail merge’ script.
- Create a spreadsheet on Google drive.
- Select Script Gallery in the Tools menu.
- Search for ‘Yet another Mail Merge’ script and install it.
- Create a draft mail.
- Mention the variables as below.
For name, mention $%Name%.
‘Name’ being the column name of the recipients list.
- In the spread sheet, select the standard mail merge option and click on the desired draft to start the mail merge.
- Unlike in Microsoft Outlook, where mails with attachments cannot be sent, using this script, personalized bulk mails with attachments can be sent.
- On an average around 2300 mails can be sent.
- A status mentioning the delivery of the mail is shown automatically in the column.
- Works intermittently. Needs constant monitoring.
- No option of stopping the process once initiated.
- The mail account might get disabled, if there are a lot of undelivered mails. This is a general Gmail feature not limited to mail-merge.
This method is generally used when attachments are to be sent in bulk mails. Otherwise, Microsoft Mail-merge is the preferred option.