Sending emails from an Excel spreadsheet

Not sure if this is possible, just looking for a simpler solution than my current practice.

Every Monday I send out 100+ emails to the same sender's letting them know which accounts they have open, each week there may be different accounts. I copy & paste the accounts with their name next to them and send a standard message. I pull everything from an Excel spreadsheet except I have email templates that are set up for me already I just paste the accounts within, type the first few letters of the recipient's last name and then send it. There has to be an easier method? I'm well versed in Excel & Outlook so looking for any ideas.

Thank you!

(Due to the privacy of the information, I'm unable to attach an example document)

HTML Code: 

You can create triggers in Excel that tell it when and what time to send the data and what data and to whom to send it to and as long as Outlook is open it will do it on your schedule. My Spread sheet currently does at least 15 different automated emails. If you don't have the time or the expert knowledge to do it go to Fiver and type in Excel in the search hire Lavina she's good. For like 25 to 50 she will do that they also have commercial services here for stuff like that.