How to send emails from Excel using a button or link that directly opens outlook and prepares the email to be sent – including a custom From address, cc, bcc, and custom subject and body text.
This includes using the hyperlink() function, the encodeurl() function, and inserting buttons into the worksheet in Excel, all of which I also explain in the tutorial.
I show you how to make this work for your workbook and it's quite easy to do once you learn the required syntax.
Download the file for this tutorial below here -->