Рет қаралды 581,251
VBA/Macros Course (40% Discount): www.teachexcel...
Send Emails from Excel Course (All You Need to Know): www.teachexcel...
Excel File: www.teachexcel...
Excel Forum: www.teachexcel...
How to send Emails from Excel using automation and also via a handy button-click.
This tutorial covers everything you need to know to be able to write simple working macros to send emails from within Microsoft Excel and also a simple non-macro method.
You'll learn how to automate:
adding multiple recipients
sending attachments
sending the current workbook
changing the email body and subject
adding CC (Carbon Copy) recipients
adding BCC (Blind Carbon Copy) recipients
and more
I also cover a common method that is used to create email macros for Excel, but that is not good practice, explain why it is not good practice, and show you how to change it to make it work better.
Enjoy!
TeachExcel.com