Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel VBA Connecting Outlook Application - Super advance
Rating: 4.5 out of 5(89 ratings)
686 students

Excel VBA Connecting Outlook Application - Super advance

Automate Outlook tasks with Excel VBA
Created byajay parmar
Last updated 7/2022
English

What you'll learn

  • You will be able to fully automate Outlook tasks using excel vba and also will get the knowledge how we connect the external applications using excel vba.
  • We are going to learn early and late binding methods which are going to be used in connecting other applications as well the same way.
  • There are multiple real projects discussed in this series for you. Questions came from students are answered here. Certainly, will save your lot of time
  • How to send Outlook Emails via VBA
  • How to provide outlook subject lines , recipients through excel sheets to fully make users powerful
  • How to create appointments and meeting calenders
  • What are the outlook classes and why and where they are used. NameSpace class, Mailitem , folders classes etc
  • Loop through emails inside outlook folders or user created folders and extract the information
  • how to download attachments from emails by searching subject lines or date ranges.
  • Move emails from one folder to another
  • How to send emails at particular time and how to track if client has replied on same or not.
  • How to send 100 emails to different senders with different subject lines and different recipients.
  • How to reply with complaint numbers.
  • Send specific range as a snapshot to Users - Mind blowing
  • Split and export outlook messages on your system
  • You will also learn the outlook VBA Topic in this session other than excel vba
  • How to create hyperlinks and attach images via excel vba and customize them.
  • How to send bold or italic formatted words in email body using ms word using excel VBA- Highly Advance

Course content

2 sections • 25 lectures • 10h 27m total length

  • Demo Video for you- a quick walk through10:20
  • Outlook Connectivity - know outlook Classes1:25:57

    This is a long and first chapter where we will learn how we connect outlook application with excel using its vba. This video you must watch slowly . Please do not fast forward. We are discussing about Outlook classes and how we connect external applications. What is early binding and late binding methods. This is must watch video before you go and see next videos.All the best. I am here to support you so any questions please ask on this forum or email me at ajayk3802@gmail.com

  • Import emails and how to send emails42:54
    • How to Import Emails information in Excel
    • How to Send emails to different users with different files.



  • Move Emails and Folders in Outlook33:04
    • How to make folders in outlook. 
    • How to copy or move existing folders in outlook using vba.
    • Move emails one by one in any of outlook folder using active-explorer method.
  • How to set up the date ranges and pick emails having specific subject line26:56

    Sharing one of my students question in this video to help you in knowing more and more about outlook connectivity. We are learning how to set up the date ranges and pick emails having specific subject lines.So, we can also move emails from one folder to another folder or sub-folder within a specific date received and also having specific subject-line. Must watch video for wanna be developers.

    Hope, you will  like this video.

  • Send different attachments with different subject-lines to different recipients20:33
    • How to send different attachments with different subject-lines to different recipients in one project.
    • Making this entire project in excel so ease our work.
  • How to track replies of emails and move them in a new folder24:17
    • How to track replies of emails and move them in a new folder.
  • Paste data as snapshot14:42

    PART8 is also has the same sort of output . Its more advance then part7 but you can use that excel file for part7 .

  • Sending multiple snapshots in single email.33:39

    how about sending multiple snapshots in single email. Come and watch this video . Watch the video without fast forwarding if you want to understand the logics and want to be fundamentally strong.

  • Multiple outlook accounts14:03

    Handle multiple accounts in Outlook

  • Early & Late Binding Discussion In general15:47

    Understanding the limitations and advantages of both early and late binding here when we connect with any other microsoft external application like word.outlook or power-point. This will make you a wise programmer and you can choose what suits you best i.e late or early binding..

  • Send email when work is done after 30min23:38

    If you want to send email when you type in "done' in worksheet cell ,just after 30min of it how email can be send. See this great code where we have clubbed outlook and events and made this magic happened. If you do not know events you can join me in vba event series as well however i tried to explain in this lecture also so that you should be able to get some idea about events.

  • 3 Questions - Surprise Test18:16

    I am giving you surprise test here. Let us see if you can do the code for these questions. I had shared the duration for this test.

    Just understand the questions and do yourself and then come back and see the answers. This is also a kind of revision on whatever we had covered so far. So , all the best

  • Outlook Project - Student help23:30

    Student emailed and asked to work on this project for her. Linking excel cells with the body content to be used in email.

  • Send specific range as file to senders - Project20:05

    One more project on student demand. How to set ranges in excel and create excel files from them and send across to specific outlook email IDs.

  • Create hyperlinks in outlook messages - Very useful Project18:41
  • how to split and import outlook body message in excel - Super advance project34:22

    one more feather in cap. Once again one great question asked by student. See how we can import outlook body content in excel by splitting it up using powerful arrays and functions.

  • Reply to Emails with Service request number- Magnificent project for you45:55

    An attempt to resolve my student question where he wanted to send auto replies to senders emails lying in one folder with some request number or identification number and also the acknowledgment that email has been received .sort of that.

    This is an incredible project because we are using many new concepts like how to select each and every email in a folder and what is active explorer ,how to run the collection loop to make sure it works on all the emails as sometime collection loops do not pick up all the emails from a folder if you have got lot of outlook emails.

  • My other Series/Tutorials with links and coupons2:12

    Dear Student, my other series information for you with links and course titles.

  • Delete or Export Meeting and Appointments in Outlook Calendar33:53

    how to delete appointments

    how meetings and appointments are set up in Calendar from excel Sheets

  • Send formatted contend in outlook body with signatures and image. -Advance Level20:55

    This is super duper fun and knowledgeable lecture which is aiming to educate you about the use of ms word application for sending the formatted emails like if you want italic or bold letters in the message along-with any type of signature.

Requirements

  • Good command over Excel VBA Basics (Any version of excel) is a must since this is the connectivity chapter.
  • You should have good knowledge of loops and local, public variables. You can see my other VBA Series . I have provided the links in this course.

Description

  • We are learning how to connect Outlook with Excel VBA.

  • Early binding approach and Late Binding Approaches. Advantage/Disadvantages

  • Sending auto emails, Customizing the email subject lines, body , signatures , to , cc, bcc ,attachments

  • Copying or moving folders in outlook

  • Copying or moving emails from one folder to another

  • How to extract the files from outlook emails and save them on your machine.

  • How to work with default folders, own created folders/subfolders

  • How to use file dialogs in emails giving choice to select whichever folder user want to choose.

  • How to send data as a snapshot in outlook body

  • There are so many things - anything which you think is a part of outlook application and you would like to automate it - can be done.

  • Multiple projects for you coming from students directly

  • For eg. how to set up meeting calendars

  • How to reply to clients with some unique request number

  • How to extract the mobile number and other information from body of outlook and export it all in excel cells,

  • How to use hyperlinks

  • How to send emails and update their status as done in excel

  • How to handle email addresses, body content, subject lines for outlook using excel sheets.

  • How to send emails with snapshots

  • How to use html tags and provide content bolder and also choose images if you want to send in body of an email.

  • Many personal projects for your confidence and exposure for eg. how to send formatted email using ms word. How to bold texts and attach logos , any logo that you like to use.

  • Early binding and late binding - Advantages and Disadvantages of both approaches.

  • Learn outlook VBA as well . In section 2,  You will see how to write same excel vba codes with little caution on outlook vba editor.

  • Your questions will be answered with in 48 hours. Always there to assist you.

Who this course is for:

  • Students who have a good understanding of Excel VBA Loops, IF functions and Variables can opt for this course.
  • This is your first step towards connecting external application with excel VBA. Be a master in automating all outlook tasks. If you want to take your programming skills to new level come and join me.

Report abuse