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!
Call:
This action will call a macro in an Excel Workbook to run. Enter the full path in the appointment Location field to indicate which workbook to open. In the appointment Subject field enter “Call:” any text after “:” will be considered the name of the macro to run. 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!