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.
I hope you enjoy this Excel email tutorial!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~ AI Course Pre-signup Discount Offer ~~
https://notify.teachexcel.com/
~~ File for this Tutorial ~~
https://www.teachexcel.com/excel-tutorial/2690/send-emails-with-a-button-from-excel-without-vba-macros?src=yt
~~ Excel Email Course Discount [50% Off] ~~
https://www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_description_i6WYXDAsxy0
~~ Excel VBA Course Discount [60% Off] ~~
https://www.teachexcel.com/vba-course-update.php?src=youtube_v_description_i6WYXDAsxy0
~~ Our Online Excel Courses ~~
https://www.teachexcel.com/premium-courses/?src=yt_description_i6WYXDAsxy0
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
00:00 What’s Covered
00:40 Excel Email Course Discount
01:08 Simple Email Popup Creation
02:35 Send Email by a Button (Simple Version)
03:29 Advanced Email Creation (No VBA)
07:21 Make the Email Formula more Readable
08:42 Add Lines to the Email Body
#excel #exceltutorial #email #msoffice #onlinecourses