I have a spreadsheet with 1000+ names and email addresses, and an email template with a slot for the recipient's name. Looks something like this:
Dear [name],
...
How can I automate filling in the name slot, and sending the email for each row in my spreadsheet?
I have programming skills, so I am open to code solutions, but I assume a tool/method already exists for this sort of thing.
Some constraints:
- These need to be sent from an email which I can access via the outlook web interface.
- I would prefer that the recipients do not see the emails of the other recipients. The answer to this question explained how to achieve that, but I need an automated solution that also personalizes the email.