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.
Excel and Excel-VBA Built-In and Custom Tools for Productivity
Today we will discuss different ways to check if a file exists in Excel-VBA.
Excel-VBA script for running simple Monte-Carlo simulations in Excel (no add-ins required).
This custom function generates triangular distribution with a specified minimum, maximum and mean.
Sometimes we have a task to go through a number of files and make some changes in each of them or pull data from them. In this article we will have a look at the Excel-VBA code which allows to do all of that.