How do I do a mail merge with Gmail?
I found EmailBee provides an easy way of doing mail merges using your Gmail account:
NOTE: If you want to send to your Gmail contacts you need to import them:
If you use Google Chrome they also have a Chrome Extension which runs inside your Gmail client on Chrome.
Here's an excellent video tutorial on using gmail, google sheets and the free Yet Another Mail Merge add-in to do a mail merge:
You write a draft email in gmail, use this format to refer to column names in your google sheet when writing the email:
Labnol has a video tutorial and walkthrough.
The key is that:
There is an update to the Labnol article that shows how to add attachments - Labnol tutorial
(thanks to mvark)