Mailmerge Emails in Google Docs
This tutorial shows how to take info from a spreadsheet and use it to send personalised emails using the new Google Apps Script which brings macros to Google Apps (but not standard Google Docs accounts, you must have your own domain name).
Requirements:
- Working Google Apps account (all editions)
- Sign-up to the service here
Summary of the steps:
- Make a copy of the tutorial spreadsheet which contains the script
- Enter some data on the spreadsheet
- Go to ‘Tools’, ‘Script’, ‘Edit Scripts’
- Click on ‘simple_mail_merge’ on the left side
- Run the function sendEmails from the bottom of the script editor window
If you want to know more, here’s an introduction to Google Apps Script:
via Google Apps Script Tutorial: Simple Mail Merge.