Today I introduce VBA functions using the emailing from Excel macro as my example. We will look at how functions are different to a sub, how to declare a function and how to use arguments, especially optional arguments. I conclude by outlining the steps in the emailing from Excel macro. Continue reading →

You can email from Excel with a macro using an email address in your VBA code or in your Excel file.  There are several different ways of doing this. This post looks at the one using a Windows Application Programming Interface (API) function called ShellExecute. Continue reading →