Click "Compose" - Create a "Draft" E-mail you will be using for Mail Merge\
Click here.\
Note - subject fields are what you are going to be replaced in the e-mails from the Google Sheets. Goto 2nd step to start the process.

Click "Compose" - Create a "Draft" E-mail you will be using for Mail Merge





--

Sales Development Representative

C: 650.339.5209

amanda@scribehow.com
Scribe | LinkedIn



Note -  subject fields are what you are going to be replaced in the e-mails from the Google Sheets. Goto 2nd step to start the process.

Tip! Here's a Google Mail Merge Link that can be helpful [https://developers.google.com/workspace/solutions/mail-merge](https://developers.google.com/workspace/solutions/mail-merge)

Create a copy of the sample mail merge and change the info for your subject fields [https://docs.google.com/spreadsheets/d/1EfjLuYGab8Xt8wCn4IokBIG0_W4tBtiU4vxl3Y7FPsA/copy](https://docs.google.com/spreadsheets/d/1EfjLuYGab8Xt8wCn4IokBIG0_W4tBtiU4vxl3Y7FPsA/copy)

Navigate to [https://docs.google.com/spreadsheets/d/1EfjLuYGab8Xt8wCn4IokBIG0_W4tBtiU4vxl3Y7FPsA/copy](https://docs.google.com/spreadsheets/d/1EfjLuYGab8Xt8wCn4IokBIG0_W4tBtiU4vxl3Y7FPsA/copy)

Navigate to [https://docs.google.com/spreadsheets/u/1/d/1EfjLuYGab8Xt8wCn4IokBIG0_W4tBtiU4vxl3Y7FPsA/copy](https://docs.google.com/spreadsheets/u/1/d/1EfjLuYGab8Xt8wCn4IokBIG0_W4tBtiU4vxl3Y7FPsA/copy)

Tip! Here's a Google Mail Merge Link that can be helpful [https://developers.google.com/workspace/solutions/mail-merge](https://developers.google.com/workspace/solutions/mail-merge)


Heads Up! Create a copy of the sample mail merge and change the info for your subject fields 

Click "Make a copy"
Change Subject fields that you are going to replace on Google sheets.

Switch to tab "Gmail/Sheets Mail Merge - Scribe Current Users - Google Sheets"

Heads Up! It will ask you to login to your e-mail that you will be sending from

Enter in the Subject Title that you are using from the draft e-mail.
Click "Ok"

Here you can see that the e-mail was sent

How to merge mail in Gmail

1st Step - Create Draft E-mail

2nd Step - Create Mail Merge Doc