Quantcast

Mailmerge on Google Sheets

Awesome tool for doing emails out to multiple people on Google Sheets :)

http://www.labnol.org/internet/personalized-mail-merge-in-gmail/20981/

1. Go to the Add-ons menu in the sheet, select Mail Merge with Attachments and then select the Create Merge Template

2. Include one or more variable fields spiderman bouncy castle with slide in the email  message using the {{field name}} notation

(http://www.labnol.org/internet/personalized-mail-merge-in-gmail/20981/)

To use Google Analytics to track open rates see this:

https://docs.google.com/spreadsheets/d/1x8lF48liTROp0UKRdoaksGEPpltPIE04eUpv9sDr6s0/copy

Track clicks

http://www.labnol.org/internet/google-analytics-track-email-clicks/2476/

Tagged with:
Posted in Uncategorized

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>