Excel/Email automation

I have a Excel spreadsheet with around 500 names containing the name of the person and their email address etc. Apart from spending weeks, typing up an standard email, adding the specific names and emails from an excel spreadsheet, I have read this process can be automated using Outlook and Excel which would save me weeks. I am using Office 365 and largely use the Web Client however can use the Outlook client on the PC if it makes it easier. All I want to do is, 1-Create the standard email 2-Save it as a template 3-Then get Outlook to run through the Excel spreadsheet, pick the 1st email in the row, then in the same row pick the name of the person and amend it in the body and send. 4-Repeat the same process for the second row, third row....for 500 people. I have seen some add-ins to buy online however wasn't sure if they actually work or how robust they were hence wanted to find out from the experts what the best solution was which was easy. Microsoft pointed me to this forum.