There have been couple of questions about how to create a robot that would send emails based on excel sheets. I created small robot to show one way of doing it. Some point of changes that could be made or options to consider:
- Add recipients emails to excel and use it when sending mails. Many companies have have emails in form of firstname.lastname@companyname.com, so option would be to generate mails from excel data.
- Html mails might not work reliably with every client
- You don’t need to read excel to dictionary so you could process all with single keyword.
Robot itself in Github