Send Emails from Excel - Automatically and Manually (Macro & Non-Macro Solution)

567,910
0
Published 2019-08-06
VBA/Macros Course (40% Discount): www.teachexcel.com/vba-course-update.php?src=youtu…

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)
  • @mrmaurya5939
    This is what i were looking for since 2 months. Thank you Creater. Great job 👍
  • @Mohammedkhan51
    Your first 17 seconds showed what i was looking for - many thanks mate
  • @aliq5522
    Great Video! Thank you so much for sharing.
  • @drisk7691
    I seriously LOVE you for making this video. This is going to save me countless hours at work. Cheers!
  • @rakirada4280
    Outstanding! I feel like a pro with this easy to understand tutorial. Thanks!
  • @Miratelmani
    Hey man this is one of the cool video I ve ever seen.. Thanks for this
  • @ramforce
    Simply brilliant. Super easy to understand.
  • 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!
  • @JimHearn
    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.
  • thanks a lot, great video, any suggestions about choosing a different sender with outlook? and adding a different signature?
  • @sorintipa5054
    Really helpful tutorial and awesome presentation. Very nice work.
  • @jholmes724
    So we’ll done. Having all these examples is excellent.
  • @saurabh62066
    Hi, thanks for this informative video. But could you please tell us how to add signature in it?
  • @SgtKingUSMC
    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.