Send Emails from Excel - Automatically and Manually (Macro & Non-Macro Solution)
567,910
Published 2019-08-06
Send Emails from Excel Course (All You Need to Know): www.teachexcel.com/premium-courses/96/send-emails-…
Excel File: www.teachexcel.com/excel-tutorial/2210/send-emails…
Excel Forum: www.teachexcel.com/talk/microsoft-office?src=yt
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
All Comments (21)
-
Downloadable File + Advanced Email Topics Covered Here: www.teachexcel.com/premium-courses/96/send-emails-… (This is a premium course.)
-
This is what i were looking for since 2 months. Thank you Creater. Great job 👍
-
Your first 17 seconds showed what i was looking for - many thanks mate
-
Great Video! Thank you so much for sharing.
-
I seriously LOVE you for making this video. This is going to save me countless hours at work. Cheers!
-
Outstanding! I feel like a pro with this easy to understand tutorial. Thanks!
-
Hey man this is one of the cool video I ve ever seen.. Thanks for this
-
Simply brilliant. Super easy to understand.
-
Fantastic - just what i needed. Thanks!
-
Hi.. great video.. you really broke it down into easy steps.. thanks! Just so I understand.. the main benefit of referencing the Object Library of the external application (in this case.. MS Outlook) is to get Intellisense when writing your code.. correct? But, the downside is that if the code is run on a system without the Object Library being enabled, then the macro fails.. thus making your first method more robust.. but with the slight detriment of not having access to Intellisense while you write your code.. correct? Thanks again for all the great tutorials.. learning a lot. Thumbs up!
-
Great job! Appreciate the extra warnings/recommendations to NOT use code that has to enable References. Good idea to avoid issues when sharing or application version upgrades. :) Would like to know if I can use the "emailItem.Attachments.Add ("C:\test\test.xlsx")" with the file reference of something like ("C:\test\*.pdf") that would allow the user to be prompted to choose a PDF file in the C:\test folder, because I already have working code prior to this statement that printed the active workbook to PDF and already saved the workbook as XLSX for future editing.
-
most comprehensive tutorial so far👍🏻👍🏻👍🏻
-
thanks a lot, great video, any suggestions about choosing a different sender with outlook? and adding a different signature?
-
Really helpful tutorial and awesome presentation. Very nice work.
-
So we’ll done. Having all these examples is excellent.
-
It's a very helpful one.Thanks for sharing.
-
Hi, thanks for this informative video. But could you please tell us how to add signature in it?
-
Thank you . Very helpful
-
Thanks a lot for all the codes. Very useful.
-
Outstanding. Never used VBA before. i just try to keep all the code making in the cells. With that in mind how do i take what you made in this video and say have it automatically generate (in display version as you stated in your code) when a cell triggers it... Example: i keep a workbook record of daily equipment status. if a cell reaches under say 80% the cell will trigger the auto email and display it... how do we get to that point.