Mail Merge Using Gmail.

Google provides many awesome services to their users, mail merge is one of them. First we talk about that why we need mail merge or on what scenario we can use merge. Suppose you are working in an organization and daily, weekly or monthly you send emails to clients to remind that their outstanding dues amount.You have huge list of clients, you want a facility to send email with different dues amount and different client’s name on single click. You can do it by gmail using mail merge facility. For this scenario, if your using software for your client data, you need to export data from software to excel sheet and them upload it into google spread sheet. Lets starts I will give you a simple example to better understanding.

Suppose you want to confirm postal address from your client:

How to?

1- For instance you have list of your clients in Google spread sheet and you want to confirm there postal addresses.

Mail Merge Using Gmail.

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.

Mail Merge Using Gmail.

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.

Mail Merge Using Gmail.

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”.

Mail Merge Using Gmail.

6- After installation your will see “Mail Merge” Option in your spread sheet’s menu bar on top.

Mail Merge Using Gmail.

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.

Mail Merge Using Gmail.

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.

Mail Merge Using Gmail.

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.

 

 

Leave a Reply

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