Send Emails with a Button from Excel (Without VBA/Macros)

Add to Favorites
Author:

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 -->


Excel Version: Excel 2016, Excel 2019, Excel 365
Downloadable Files: Project File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Get User Submitted Data from a Prompt in Excel using VBA Macros
Tutorial: How to prompt a user for their input in Excel. There is a simple way to do this using VBA ...
Monitor Data in Excel without VBA/Macros
Tutorial: How to monitor cells in your workbook from a single and easy-to-manage setup that allows ...
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Macro: Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a grea...
Email List of People from Excel Using a Macro
: Send Emails from Excel Course Send emails to everyone in a list in Excel using a macro. Th...
Make a UserForm in Excel
Tutorial: Let's create a working UserForm in Excel. This is a step-by-step tutorial that shows you e...
Link Worksheet Form Controls with Cells on Protected Worksheets without VBA Macros in Excel
Tutorial: Simple method to use Excel Form Controls and ActiveX Controls and link them to cells on p...
Tutorial Details
Excel Version: Excel 2016, Excel 2019, Excel 365
Downloadable Files: Project File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course