Excel and Excel-VBA Built-In and Custom Tools for Productivity

How to send mass emails directly from Excel using VBA without Merge

A version of this script has been used to create personalized emails for a list of clients. In my opinion this is much cooler than the in-built merge function because it allows to automate complex calculations and generate any kind of personalized email (even with HTML markup), attach files (which you can also generate on the go right before you send) and whatever else comes to your mind.

 


Support the project

Please feel free to support me on Patreon.