I'm attempting to personalize an email that uses HTML coding. Basically, I've made an HTML template that I want to have say the name of a person within the HTML code as well as the subject line of the email. For example: Subject line would be "Welcome to the club [name of contact]" and within the HTML body text have [name of contact] show up again. I'm using a Google Spreadsheet that has been scripted to run mail merge. Everything runs through the document. I've put all of the contacts on the spreadsheet with the script. Is this possible to personalize this?
Google-sheets – How to personalize HTML emails using Mail Merge and Google Spreadsheets
google sheetsmail-merge
Related Topic
- Google-sheets – Mailmerge via Google Sheets: multiline cell content
- Google-sheets – Attach image url then email using Google Sheets
- Google-sheets – Adding a Generated QR Code from Google Sheet to an Avery “Mail merge” template in Google Docs
- Google-sheets – How to get the name of a colleague from the Google Account email address within a Google Sheet
Best Answer
Data from a spreadsheet can be inserted into a Gmail draft email (which can contain HTML) by using the Yet Another Mail Merge add-on in Google Sheets.