Excel VBA Introduction Part 29.2 - Outlook Email Events

[@CazzMagnetic]

Andrew, thank you very much for your help, I cannot begin to explain how helpful your videos have been to me personally and professionally, you have unlocked a potential I never thought I had! All the way from South Africa- Johannesburg

[@asadmahboob1123]

Hi Andrew, I am grateful to you and wise owl for all the videos...when I was naive in VBA, you helped me alot. Now, I am a part of excel automation team. I have automated around 50 excel reports..and now I am preparing for Python programming....once again I want to extend my thanks to you and wise owl team...

[@cu806]

I'm trying to figure out what python can do in excel and do you use bumpy? Response would be appreciated it

[@ComercioExteriorUV]

Always surprise how much effort you put on the videos. Thanks a lot!

[@WiseOwlTutorials]

My pleasure, Mauricio! Thank you for watching and for taking the time to comment!

[@fabriciocarranza7044]

I am so grateful , it would have taken me years to achieve what you did in days. I am astonished . Thank you again

[@ravisrir]

Just wanted to thank you for your VBA video series. I can honestly say that I had no clue about VBA before watching the videos and now I have successfully been able to automate a lot of my work.

[@maurocastagnera8949]

Dear Andrew, I'm getting better with my English, so it's always more fun to watch your videos. I really believe that at the end of your video series a person will really learn something great and get an excellent professionality to work in any business area. You really deserve to be grateful for the great opportunity you offer to those who have a good will to commit themselves doing something important for their life, that is, to learn a great profession. The world should be grateful to you! Thank you very much again! Excuse me if my English contains a few mistakes.

[@chandankumar-np9ez]

All video from u are Greatest learning video available on KZbin.

[@mrfallahpour1180]

That's quite impressive I found out there is a new added video regarding email events.Thanks Andrew.

[@priscillaschmidt4849]

Wooaaaoooo, amazing, thank you so very much for this video , it is exactly what I was looking for. I am so grateful, you are the best teacher. In fact my name is Fabricio, Priscilla is my wife, I did not have an account to make comments, but now I do, therefore, i will keep following you using my account under my name. I really appreciate your help. God bless you, if I lived in U.K. I would attend to your classes indeed.

[@officesuperhero9611]

Another great video! Just seeign that you post any new video is exciting because I learn so much from you. Another topic I hope you might consider is how to incorporate and call various Windows API in VBA. I know you have touched upon it here and there in different videos, but one or two videos on Windows API with VBA would be great. THere are so few out there and the ones that do exist are not nearly as clear as you would do it. Anyway, hope you will consider it. And thank you again for sharing your incredible knowledge with us. The VBA community is very grateful.

[@josebetancourt5890]

Wohooo 20 thumbs up!!! I hope to see more outlook videos in near future. Thanks!

[@hareeshnalubolu4179]

Hi Andrew Thank you very much for all your videos, eagerly waiting for more videos from you

[@kiwinesss]

Anxiously waiting for more videos!

[@syzygzy]

Absolutely brilliant, as always ☺️

[@byteseq]

A class that references a public object, OMG! Do even go there.

[@krn14242]

Thanks Andrew. Lots of useful tricks.

[@fabriciocarranza7044]

Hello hello , greetings , thank you very much again, I am Priscilla' s husband. Nice to meet you

[@binu.p.s5024]

Absolutely brilliant as usual. can you also please make a video on how to take screen shot using Snapgit automatically with VBA

[@ShootaMagic]

Great as always.Thanks Andrew!

[@SergioAlejandroCampos]

Great video.

[@charlesajouri7233]

Welcome back!!

[@kashifkhanspecial]

Hi, Thanks for this lovely video tutorial, I have never seen these kind of tutorial on KZbin. I have one request to you, can you please upload video series about ribbon control in excel, that how can we add new ribbon in excel and how can we add our own controls in the ribbon and how can can we create dynamic ribbon and how can we manipulate ribbon controls from VBA. Thanks in advance. Once again thanks for these knowledgable video tutorial. Thanks Kashif

[@pallikishor]

I have gone through all the videos of playlist. And it has really helped me. could you please make some videos on Excel VBA APIs?

[@mikefreeman3050]

Kishor Palli I wish that too. Andrew' started talking about Windows API functions in Part 49 - Downloading files from websites. I found an interesting article about them. www.informit.com/articles/article.aspx?p=366892

[@pallikishor]

thanks mate.

[@zaimcfpa7242]

you are best teacher

[@Howtoexcelatexcel]

Awesome as ever

[@forzaalgiers2045]

welcome back !!!

[@irynamusiiovska828]

Thank you!

[@janezklun]

Great tutoria,l as always, thank you

[@fabriciocarranza7044]

You are the best!!!!

[@walterkendall170]

Fantastic. Wondering if you could do a follow video dealing with this topic and different versions of Office; say 2007 and 2013.

[@low_quality666]

walter Jung was thinking of me. neutral if it's

[@walterkendall170]

WiseOwlTutorials Thank you so much. Your organization is invaluable to me.

[@technickuk]

Really informative and easy to understand video. Just wondering though, is it possible to have it all use late binding so that you don't have to add a reference to the Outlook VBA module? I'm thinking perhaps not due to the WithEvents, but willing to be corrected if I'm wrong.

[@-Harambe]

HI Andy, do you know much about XSLT? By the way, I've been your longest follower and I've learned so much from you to almost keep my job. I'm having an issue running my xslt file in newer .net 4.7.2 version. I get error "The stylesheet is too complex". I'd appreciate it if you can help or point me to a right direction.

[@Grahamedmonstone]

Great tutorial. Once you've created withevents I noticed a whole library became available. Is there an event that shows Email bounced back? I had used your method with a few changes to send multiple Emails and would like to log those that bounce back.

[@srdjadzogaz286]

You are great teacher, i just wish you did Python :)

[@vivekr4690]

Yeah even I was about to say the same thing!

[@jielu5369]

really appreciate your video, you are a excellent teacher, a lot of thanks from a Chinese student. I am a absolute beginner on these stuffs, know nothing about IT, I want to get information( the variety and prices) from a medicine web, and put them into Excel, which of your video is best for me to learn it? Could you give me some advice please? I am an accounting student, really confused about this...

[@jielu5369]

So many thanks for your reply, it's indeed helped me! I will recommend you to my friends, you are great at teaching.

[@zaimcfpa7242]

Thank you

[@NEGAO46643]

Brilliant class, though i have a question. Imagine the recipient of the email does not exist anymore, for instance an employee that have been made redundant in a company and been dismissed, and my routine send automatic emails with individual reports, but these especific one doesn't reach the recipient and i would like an email was sent to the current address configured in Outlook warning the error? Thank you in advance.

[@kashifkhanspecial]

Hi, Thanks for this video tutorial, I have one request to you, can you please make a video tutorial about how can we fill or edit a PDF from Excel VBA and pull the data from PDF or fill the PDF from Excel table from Excel VBA. Thanks in advance. Kashif

[@timbollmer6019]

Thank you for all of the details. I do, however, have a favor to ask. Can you make an extention to this video that shows a proper way to email a copy of the workbook you are using, save the file as the name in a cell & the date from another cell to a list of emails stored in one of the sheets?

[@timbollmer6019]

For the save function...what if this is going to be used as a "blank program" that gets distributed and I want put it in s specific folder. Example: "MyDoc" saves to "My Documents" in folder "MyProgram". Problem is it is located on multiple computers/profiles so how do I tell the program to save to the correct folder?

[@timbollmer6019]

Awesome! Much appreciated!

[@drs10301]

Hi sir Any video on task scheduler in detail as I am looking for tasks to run automatically at scheduled time which will help me in reducing some man-hours

[@ayizeakono8492]

Thanks alot Andrew!!!! I've learned so much from you...I've come across an Add-In called Rubber Duck for the VBE, please check it out if you haven't already

[@aaronlefcovitch4291]

This is a great tutorial! Would this code work if i was to put a for loop in to send out multiple emails, with addresses in a workbook?

[@dianthus1666]

I really want to do this. automatically send multiple emails with status either sent or not, but how?

[@vittal255]

I have seen the videos all the tutorials are great. I need help. I want to write a VBA code to send emails with an email id using outlook. I want to change the name of the email using VBA code. I want the recipient to see a different name instead of my name. Is that possible ?. Thanks for the tutorial once again

[@ibtsamhamid5353]

CAN WE PUBLISH THE VEDIO AT OUR LEARNINGCHANNEL NOT Profitability CHANNEL?. IF YOU ACCEPT.KINDLY LET ME KNOW. THANKS IN ADVANCE

[@drs10301]

Hi, I want to know how to copy range from excel and paste as image format(bitmap) in outlook body of email using VBA Please help me

[@nonenone2858]

Hi, Is it possible to have a word file that was just created take some data(names and values) from inside it and automatically introduce those values in the title of the file? When I close the new document at exit to have the file renamed in my folder automatically by taking the data of choice from inside it. what videos do you recommend watching that have the pieces I need to learn to be able to do it?

[@AmitJain-dq4kq]

Hi, I am looking for help on how to capture "PROPERTY CHANGE" Event, when a category is added to an email. Basically, I have defined a category "REMIND" and when i change category of any e-mail in my mailbox, a copy of this email maessage should be saved in Folder "Reminder"

[@WiseOwlTutorials]

Hi Amit! I'm not familiar with doing that but you might find this helpful as a starting point stackoverflow.com/questions/47266652/how-can-i-implement-the-propertychange-event I hope it helps!

[@rohankedari292]

I cannot attach mail trail in outlook vba

[@rraushan2088]

Hi can you help me I want if value is anywhere in sheet1 and when I put the same value in sheet2 any cell I get that value address in front of that....help me if it’s possible with vba code pls send me vba code for this....pls help me.....

[@rohankedari292]

Sir I m fa ding challenge while replying all in outlook vba

[@lukaszpiech9130]

Welcome back!!!