This is an Outlook macro designed to trigger Excel actions from your Outlook Calendar. Simply schedule an appointment with the “Excel” category. This macro will then review the appointment subject field to determine what action to complete. Then based on the values in the other appointment fields proceed accordingly. The desired action will fire when the appointment reminder is triggered. You can also reoccur the appointment for routine actions to apply in the future!
Create:
This action will create a new Excel Workbook and save it to the path identified in the Location field of the appointment. In the appointment Subject field enter “Create:” any text after “:” will be consider the name of the Excel Workbook created. Watch this video to see this macro in action.
Code:
Follow this link to access all the code for the Leverage & Lean Calendar Reminder Macros!