Macro Instructions | Outlook Looping In [Macro #28] | Macro Monday 07.20.20
You receive an email with a question and notice that this isn’t something that you should be answering. Either you don’t know the answer or maybe you don’t have the authority to respond. The good news is you know who should be looped into this email. So, you respond CCing the correct person and move on. If this situation happens enough you start to realize how much time you are wasting just to pull the appropriate recipients into an email. If you want to be more efficient start using our Looping In Outlook macro today! Running this Outlook macro will display an InputBox that you can custom to display potential recipients to loop into the current email. Entering the leading number of the appropriate recipient automates three actions. The recipient’s email is automatically CCed to the current email, text appears indicating that they have been looped into the email, and a MsgBox displays giving you an opportunity to automatically send the email now or stop to make more edits before sending. Stop wasting time completing these actions yourself and let your computer help you achieve Less Clicks and More Results!
First time using VBA? You just need to complete 3 easy steps that only take a couple minutes to complete: Activate the Developer Tab, Update Macro Security, Setup References for Leverage & Lean macros. I'll show you how to do all of this in this Macro Monday video!
Want to make this macro your own? These lines of code can be customized to personalize this macro.
16 through 20 'Labels to the Looping In options Update the Looping In Text # to display a label to map CCRecipients to a leading number.
28 through 39 ElseIf Action = "1" Then For each section of code that indicates an Action number populate the variables LoopingIn and CCRecipient with the appropriate values
60 through 63 'Answer = MsgBox("Do you want to send the email now?", vbQuestion + vbYesNo + vbDefaultButton2, "Outlook Looping In") Make these lines of code active to display a MsgBox give you an option to immediately send an email after looping in the necessary recipients
#LeverageLean #LessClicksMoreResults #MacroMonday #VBA #Macros
Find more content on our website: https://leveragelean.com
Watch all of our Macro Monday Videos on our YouTube playlist: • Macro Instructions | Macro Mondays
Subscribe to our YouTube Channel to stay up to date on all of the videos we are posting.
/ @leveragelean
Like us on Facebook: / leveragelean
Follow us on Twitter: / leveragelean
Connect with us on LinkedIn: / brentschneider-leveragelean
Check us out on Instagram: / leveragelean
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!" To see our content visit LeverageLean.com where we have Visual Basic Applications (VBA) Macros in Excel, Outlook, and Word that automate repetitive computer tasks. You can start using this macro today for FREE, No Charge, No Gimmicks!!! Come visit us and watch our additional Macro Instructions videos to see how to implement our VBA macros in your computer processes and customize them meet your specific needs. Macros helps save time and time is money it’s as simple as that! Also, walkthrough our PDF Tutorials step by step or watch our See How videos to utilize computer settings that have been hiding in plain sight. Read our weekly Insights that open your mind and challenge you to start improving your computer processes. Leverage & Lean Insights are a quick read (less than 1 minute on average) but can be a great reset to your day and help you focus on how to start winning on your computer!
Stay Awesome,
Brent Schneider
Leverage & Lean
Est. 2017