Excel VBA Connecting Outlook – Chapter 12

4.00 out of 5
(1 customer review)


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,

1 review for Excel VBA Connecting Outlook – Chapter 12

  1. 4 out of 5


Add a review