Excel VBA Introduction Part 29.2 – Outlook Email Events




About this tutorial:

Video duration: 33:45
If you’d like to help fund Wise Owl’s conversion of tea and biscuits into quality training videos, you can click this link to make a donation. Thanks for watching!

You can buy our Introduction to Excel VBA book here

By Andrew Gould

You can download an example file here

– This video explains how to use the WithEvents keyword to access the Send and Close events of…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

29 thoughts on “Excel VBA Introduction Part 29.2 – Outlook Email Events

    Aaron Lefcovitch

    (July 10, 2018 - 3:16 am)

    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?

    Ilya Zhidkov

    (July 10, 2018 - 3:16 am)

    You are amazing! I wish you could upload more educational videos or payed courses. Please keep going!

    Bilwadal Chowdhary

    (July 10, 2018 - 3:16 am)

    Sir,
    I want to create my own function for making Bold a cell value. Like this
    =BOLD(A1).
    Can anybody tell me the exact code in VBA editor under Function BOLD ? Like this …

    function bold()

    bold = ……….????………….

    End function

    please suggest me the code…

    Kashif Khan

    (July 10, 2018 - 3:16 am)

    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

    preben nielsen

    (July 10, 2018 - 3:16 am)

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

    How To Excel At Excel.Com

    (July 10, 2018 - 3:16 am)

    Awesome as ever

    RAKESH SHARMA

    (July 10, 2018 - 3:16 am)

    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…..

    D Shekar

    (July 10, 2018 - 3:16 am)

    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

    Harambe

    (July 10, 2018 - 3:16 am)

    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.

    Clashing Hunt

    (July 10, 2018 - 3:16 am)

    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…

    Sadiefy Rivera

    (July 10, 2018 - 3:16 am)

    Genuine office 2016 product key can be got from link #plus.google.com/u/0/104028188633487744432, works so well, and the price is also very reasonable.

    ZAIMCFPA

    (July 10, 2018 - 3:16 am)

    you are best teacher

    ZAIMCFPA

    (July 10, 2018 - 3:16 am)

    Thank you

    Bob Beamon

    (July 10, 2018 - 3:16 am)

    Anxiously waiting for more videos!

    Tech Nick

    (July 10, 2018 - 3:16 am)

    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.

    LIQUID SNAKE

    (July 10, 2018 - 3:16 am)

    can anyone help me on How to catalog all files in folders/subfolders in excel vBA?
    Kindly watch this video https://www.youtube.com/watch?v=vliCSzCrrR4&t=

    If anyone here is a bigheart and willing to share his/her knowledge to reddit community kindly click the post below and post your answers there so everyone can see. Thanks!

    https://www.reddit.com/r/learnexcel/comments/7e8fws/how_to_catalog_all_files_in_folderssubfolders_in/

    TJ Bollmer

    (July 10, 2018 - 3:16 am)

    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?

    Mauro Castagnera

    (July 10, 2018 - 3:16 am)

    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.

    Ibtsam Hamid

    (July 10, 2018 - 3:16 am)

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

    Graham Edmonstone

    (July 10, 2018 - 3:16 am)

    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.

    Binu .P.S

    (July 10, 2018 - 3:16 am)

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

    Essam Adel

    (July 10, 2018 - 3:16 am)

    Dear sir
    good day
    kindly contact with me for ask you about how can open website and get data to excel
    phone +96566615090

    Regards

    Caswell Nofuma

    (July 10, 2018 - 3:16 am)

    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

    Kishor Palli

    (July 10, 2018 - 3:16 am)

    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?

    krn14242

    (July 10, 2018 - 3:16 am)

    Thanks Andrew. Lots of useful tricks.

    Marek Cudny

    (July 10, 2018 - 3:16 am)

    Great as always.Thanks Andrew!

    Mohammad Reza Fallahpour

    (July 10, 2018 - 3:16 am)

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

    Ilya Zhidkov

    (July 10, 2018 - 3:16 am)

    Hi Andrew, any C# / ASP.NET content in future?

    Fabricio Carranza

    (July 10, 2018 - 3:16 am)

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

Leave a Reply

Your email address will not be published. Required fields are marked *