

Once you are done doing the email body, save the email (gmail automatically saves your draft mails) and return to Google Spreadsheet (in Google Drive) Give a link to emails, website, driving directions etc.You can even customize the subject line by the same method.Where ever you want to add column headers simply include them in your mail body this way…$%Name% Go to your gmail account and write the mail body that you want to send to multiple contacts. You could let the first row of the spreadsheet be field names, and create a template document where. After you are done punching (or copy pasting) the contact details, save the spreadsheet with a suitable Name (Go to FILE menu -> Choose RENAME option) You will need to write a Google Apps Script for that. Note that each row should be filled with information under the column headers.

You can dump all the contact details in the spreadsheet. You will find the link to create a Google spreadsheet in the Google Drive, log in with your Google Account and Create a Spreadsheet Contacts – Use your own contacts please 😀 !!ġ.) Set up a Google Spreadsheet with your contact list.Email – I am sure you would have it, but if you still need I’ll have a standard mail during this tutorial.If you don’t have any one of them, grab them here You need to have these ingredients for today’s recipe. the Google Way!! 😎 First things first – Google Account, Email Body & Contacts Spreadsheets, Presentations, Word Reports seem to be the forte of Microsoft, but I figured out that Google is as powerful in its mail merge capability… Let’s do this and for a change.
