Learn MS Excel – Video 406- VBA Loop- Create Mutiple Outook Appointments in Outook Calendar



Using Excel Spread sheet we are creating the appointments in outlook calendar . Fastest and easy way to create appointments using VBA

-~-~~-~~~-~~-~-
Please watch: “Learn Excel – Video 594 – VBA – WEB SCRAPING – CLICK ON SEARCH BUTTON”

-~-~~-~~~-~~-~-

4 thoughts on “Learn MS Excel – Video 406- VBA Loop- Create Mutiple Outook Appointments in Outook Calendar

  1. Ajay. You are a legend. I have used your basic VBA for a couple of gantt charts and they work excellent. I have one question. In your tutorial, you have an automatic time entered in as an "end time". I have created a formula in mine via the IF function, however now that i have done that i have a Runtime error 13 Type Mismatch. What could i be doing incorrectly. Thanks

  2. Thanks for this Ajay, excellent tutorial and very easy to follow. One thing though, how do I stop it from creating duplicate calendar items every time I run the macro? What I would like is to create a calendar reminder for each new entry when it is entered on the sheet, but obviously not for the existing entries. Many thanks again.

Leave a Reply

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