I have a list which contains e-mail id, name, designation and company name of the users.
I want to send an e-mail to all of them at once using a script or something else. Here is what i want to achieve-
The mail contains 3 fields which are changing every time i send a mail.
1. Mail ID filed
3. Name in the e-mail body.
The format will be like this -
T0 - "E-mail ID"
Subject - "Name - Designation@company name".
Mail Body -
Usual way is to draft each mail by replacing the above fields and send one to one.
How do i automate this process and send mail to multiple recipients?
I need a script or any other solution which will replace above fields automatically as per the list (Excel sheet) and send mail to all of them.
Any help / inputs will be highly appreciated.