The playground
Bjorn

Bjorn's Mail Merge

Mail merge with Google Docs and Google Sheets

Swiftly send bulk email from Google Docs™

Maintain often used email lists in Google Sheets™

Use "variables" to easily reuse email templates

Store often used email templates in Docs

Samples

See this Google Sheet on how to configure your spreadsheets.

Here is a sample Google Doc setup to use variables representing data in a Google Sheet.

System variables

VariableDescription
DateThe date when document is created
Date:shortThe date when document is created, short format
Date:isoThe date when document is created, ISO format
TimeThe time when document is created
Time:shortThe time when document is created, short format
Time:isoThe time when document is created, ISO format
UserEMailYour email address
UserNameYour name
UserFirstNameYour first name

More

Check out this short YouTube video.

Check out screenshots and install from the web store.