Suppose you want to confirm postal address from your client:
1- For instance you have list of your clients in Google spread sheet and you want to confirm there postal addresses.
2- Compose an email as normally your compose in Gmail. Type a matter for address confirmation, and save it. Do not send now.
3- Let “To” blank and Replace the text which you want to change via spread sheet with “column name in spread sheet”, suppose replace “Dear Joseph” with “Dear name”. Just you have to include little special character with it. (Example: $%name%). do the same with all column name which you want to insert into your email.
4- Now go back to your spread sheet and select “Tool” from menu and then select “Script Gallery”. This will install a script for mail merge.
5- There are many script in it, I will give example with “Yet another merge” script, select it and install this script. It will ask you for “Authorization” Just click on “Continue”.
6- After installation your will see “Mail Merge” Option in your spread sheet’s menu bar on top.
7- Now click on “Mail Merge” and the click on “Standard Merge”. For first time it will ask you for recipient field name, select the “Email” column of spread sheet.
8- In next window it will show you your email, which you have just written and saved it, select that mail and write sender name below.
9- Finally click on “Send Mails”, when sending process complete it will show you “Done” status in your spread sheet on each recipient.
10- You done successfully done mail merge with Gmail.