I can consider two choices you could possibly look into:
Write your individual
Because you already programmed in AppleScript, would you be positive writing bigger packages in one other scripting language?
Languages like python would give you a method to hook up with a mail server and ship the messages for you. No less than if you’re solely sending plain textual content mails, this is perhaps ok. With extra advanced mails, I might think about that formatting them correctly is a little more tough…
Use a neighborhood desktop app
You could possibly get an app that runs domestically in your machine and processes your csv file to ship out the mails. These apps act like a traditional email consumer, so with this, you could possibly preserve utilizing your commonplace email account and would not have to fret about importing your knowledge to a cloud service.
At my earlier job we used the app SerialMailer for this. Importing a CSV file after which sending out personalised messages to every entry. It labored rather well for us, however I believe there are additionally another apps on the market you could possibly strive.