Macros

Calendar Reminder Macros

NEW & IMPROVED in 2021!

Welcome to the Calendar Reminder Macros page where you can learn all about Leverage & Lean’s Calendar Reminder Macros.

We are sure you have some questions like:
A Calendar Reminder Macro is an Outlook Macro that refers to your Outlook Calendar looking for Appointments that are setup to trigger specific actions. Got it?
It is a Calendar “Reminder” Macro because the Outlook Appointment’s Reminder controls the timing of when the specified action will fire. Timing is everything!
Leverage & Lean Calendar Reminder Macro’s interact with Microsoft Office Applications: Access, Excel, OneNote, Outlook, PowerPoint, and Word. Within these Applications you can trigger actions like Call, Copy, Create, Open, and Send. Learn more about these actions in the cards below!
To install Leverage & Lean Calendar Reminder Macros you need to copy the Code below. You can then navigate to Outlook, the Developer Tab, and open Visual Basic. Within Visual Basic open ThisOutlookSession found under the folder Microsoft Outlook Objects. Paste in the code directly into the Outlook Session.

You will also need to setup the following references by navigating to Tools and selecting References:
Visual Basic For Applications
Microsoft Outlook 16.0 Object Library
Microsoft Office 16.0 Object Library
OLE Automation
Microsoft Forms 2.0 Object Library
Microsoft OneNote 15.0 Extended Object Library
Microsoft OneNote 15.0 Object Library
Microsoft Access 16.0 Object Library
Microsoft XML, v6.0
Microsoft PowerPoint 16.0 Object Library

First time using VBA? Get started with the three steps mentioned below!
That is AWESOME! Leverage & Lean Calendar Reminder Macros are POWERFUL and will help you automate your life. Once installed you can create Outlook Calendar Appointments to trigger actions and even set them to fire reoccurring! Checkout the cards below that will explain how you need to setup Appointments to fire certain actions. There are plenty of parameters to use to customize how our actions will fire. The possibilities are ENDLESS!

First time using VBA?

Get started with these three easy steps!
Want to learn more about getting started with VBA?

Power your Outlook Calendar to do MORE! fire ACTIONS! increase PRODUCTIVITY! create ROUTINE! work in RHYTHM!

The Code

Here is the code for the Leverage & Lean Calendar Reminder Macros. Start using this VBA code to fire all the actions mentioned in the posts above! Make sure the following References are setup before running it: Visual Basic For Applications, Microsoft Access 16.0 Object Library, Microsoft Excel 16.0 Object Library, Microsoft OneNote 15.0 Object Library, Microsoft OneNote 15.0 Extended Object Library, Microsoft Outlook 16.0 Object Library, OLE Automation, Microsoft Office 16.0 Object Library, Microsoft PowerPoint 16.0 Object Library, Microsoft Word 16.0 Object Library, Microsoft Forms 2.0 Object Library, Microsoft XML, v6.0

Like . Follow . Subscribe . Connect

Facebook Twitter Instagram Linkedin Youtube Github

Contact Us

Looking to improve your computer processes?
Leverage & Lean is here to help!

Stay Awesome!

Leverage & Lean

Is focused on improving computer processes by Leveraging programming and applying Lean principles. It is our goal to make you more efficient and effective on your computer producing “Less Clicks and More Results!”

Get Started

Macros

Lean

YouTube

Copyright © 2019 Leverage & Lean
Facebook-f Twitter Linkedin-in Instagram Youtube Github
Powered By MemberPress WooCommerce Plus Integration

In regards to Word Create Outlook Email with Selected Text | VBA Macro #29

This is so perfect!
Thank you so much!

At my job, we recently switched over to Office 365. Previously we had an email template that we could fill out (using field codes [select all+F9]) but that is no longer available in Office 365, as only Word has the Field Code capability now.

I was trying to find some sort of solution using Word, and yours was the best thing I could find on the web!

Very straightforward!
Very appreciated!
YOU are the awesome one!

Allen

In regards to Excel Find and Replace across Multiple Word Documents | VBA Macro #30 and custom work.

The use case for CheckTheBible.com was to convert all the variations of Bible verse codes (B C:V - Book Chapter:Verse) in any text to a standardized code. For example, "John 17:21" should be "Joh 17:21." Once the variations are converted, then the next step is to convert them to a markdown language so they can be used in Obsidian.

I found Brent through his YouTube channel: Leverage & Lean (https://www.youtube.com/LeverageLean). Out of all the macro videos, the "Excel Find and Replace across Multiple Word Documents" video seemed like it could help automate a seemingly manual process.

I contacted Brent to see what could be done with my use case. From our first discussion, Brent has always been very understanding and patient with my situation and listened to my suggestions for improving the macro’s speed and efficiency.

Once he understood the end goal, Brent took my improvements to heart and ran with them. Now with this improved macro, I can take on any set of variables, modify a few words, and convert them to the final result. This custom macro searches Word Documents for Bible verse codes, uses a standardized list of 30+ thousand B C:V codes to convert to the markdown language automatically with 100% accuracy.

I have had a great experience working with Brent. Not only does he clarify expectations so it was set up for success, but most importantly, he has always come up with creative and comprehensive suggestions even outside the scope of macro building. Brent was really consulting me to do more than what I had thought possible.
Edward