Excel VBA Connecting Outlook – Chapter 12


4 Collection Loops



  • 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 ,attachements
  • 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,


There are no reviews yet.

Be the first to review “Excel VBA Connecting Outlook – Chapter 12”