I want to sent emails through my google spreadsheet which have data like recipient's name,email address,subject.
I have a docs(word) template containing the message body.
I need a script to send emails to each recipients in my spreadsheet with the corresponding subject line and a personalised template( i want to insert variables in my template like the recipient's name to look my email more personalised and impressive)
Can you help me on this.
I actually found a script at the following link but it has not the option to personalise the subject heading. So, you can help me by making appropriate changes in this script.
Thanks in advance.