Home Computer Tips How to use Google mail merge?

How to use Google mail merge?


Learn how to send bulk emails to different recipients with the same body, with different greetings and with different file attachments to each people also send emails as per the schedule time and date with some small limitations using google mail merge.

There is one of the wonderful feature given by google is mail merge. We can send emails to different recipients with the same body of the mail, with different greetings and we can send different attachments to different people. This google mail merge will helpful to send bulk emails to different recipients but only the limit is we can send emails up to 100 daily, and the file attachments size should be less than 25Mb.if we want to forward resume, party and function detail it is best option to send different people through google mail merge.

Let see how to use google mail merge step by step:

Step 1: Go to Mail login page. Login with your login details

login to gmail

Step 2: create a draft message.in that draft body of the mail, you can write what message you want to send. You can also use google docs to create the body of the message.

create a draft message

Step 3: open google drive.

open google drive

Step 4: open google spreadsheet.

open spread sheet

The spreadsheet looks like this.

google spread sheet

Step 5: Go to add-ons press enter.

Open Get add-ons. On search box search for mail merge with attachments.it is free to use. Get add –on. And allow to access you Gmail contacts.

Then mail merge is added to yours google sheet. Open mail merges with attachments. Create merge templet as shown.

mail merge addon

You can set first name, last name, email address, file attachments and scheduled date.

set details

Step 6: go to configure mail merge template. you can add bcc, sender full name, address optional

configure mail merge

Step 7: we can add full name, cc address, bcc address if required after completion of details select choose email template

choose templet

Within the configure and run the mail merge. Select existing draft template from Gmail. Choose corresponding Gmail draft message.

choose draft templet

Step 8: click start Run Mail Merge.

run mail merge

Step 9: that’s all mail merge completed. Check you sent mail in Gmail whether mail sent or not. Thank you.if any doubts regarding mail merge please comment below.

see video: How to use google mail merge?