Click review permissions and authorize it. You will be asked to authorize the script.Go back to the spreadsheet and navigate to Mail Merge -> Send Emails.Copy the subject line of the email template.Go to your Gmail account and compose your email template.This is going to get updated by the script after it sends out your emails, so keep this column blank. You can also choose to keep or remove the last column (Email Sent). Make sure to update the recipient email addresses in the Recipient column correctly. Customize the spreadsheet’s columns according to your requirements, depending on the data you want to include in your email template. Click here and make a copy of the spreadsheet.
0 Comments
Leave a Reply. |