0
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.
How would I find my SMTP server IP address? Or is that something I would need to set up? – Ababwa – 2019-05-09T20:33:18.890
@Ababwa Are you sending this from a company/work PC? or your own personal PC? – Lawrence – 2019-05-10T01:09:55.697
These will be sent from my personal PC. – Ababwa – 2019-05-14T19:19:43.970