Building an e-mail merger application

Sending personalized e-mails to hundreds of recipients at a time might be a time consuming task. Composing the draft and entering the subject and recipient's e-mail ID for each message might be tedious too. Using this mail merger application, you can send the same kind of information to all recipients, but customized to some extent. For example, greeting an individual.

The first step is creating a draft in your Gmail as shown in the following screenshot. The draft is used as a template. You can use any special character to enclose the text to be replaced. In the draft, the code shown in the following screenshot uses left (<<) and right (>>) angled brackets to replace the first name with the First Name column ...

Get Learning Google Apps Script now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.