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.
2nd Step - Create Mail Merge Doc
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
3
Click "Make a copy"
Change Subject fields that you are going to replace on Google sheets.
4
Click "Continue"
Heads Up! It will ask you to login to your e-mail that you will be sending from
5
Click "Allow" to grant access
6
Click "Mail Merge"
Click "Send Emails"
7
Enter in the Subject Title that you are using from the draft e-mail.
Click "Ok"