Get started using Excel VBA by allowing the Macro Recorder to generate the code for you! This tutorial will show you how to record a macro in Excel that will create a new Worksheet. With some additional steps you can have this VBA code fire every time the Workbook opens.
Outlook gives you the ability to create memorized actions called Quick Steps. One helpful Quick Step you can create is a standard email to send to all recipients of your department. Using this Quick Step, you can quickly email your entire department keeping everyone informed. Think of Quick Steps as a toolbox that you add tools to over time. Leverage & Lean is here to help fill your Outlook toolbox!
If you find yourself typing the same thing over and over again take a moment to create AutoText in Word! AutoText can be a few words or entire sentences you decide. AutoText makes typing more efficient and can help you get more done in Word.
Outlook gives you the ability to create memorized actions called Quick Steps. One helpful Quick Step you can create is to forward a selected email to your supervisor. Using this Quick Step, you can quickly Forward an email to your Supervisor. This is a great way to inform your Supervisor of critical information in a quick fashion! Think of Quick Steps as a toolbox that you add tools to over time. Leverage & Lean is here to help fill your Outlook toolbox!
If you have completed a Mail Merge in Word it is time to take things to the next level and create an Email Merge! An Email Merge is very similar to a Mail Merge but instead of Letters you are creating Outlook Emails. The Email Merge function helps you send a large number of emails to a list of recipients quickly out of Microsoft Word. The Email Merge feature is a collaboration across the big three applications Excel, Outlook, and of course Word!
Lights Camera Action! With the Macro Recorder you are the director of your own macro movie. Excel gives you the ability to capture all of your repeatable actions when recording with the Macro Recorder. Get started using Excel VBA by allowing the Macro Recorder to generate the code for you!
Outlook gives you the ability to create memorized actions called Quick Steps. One helpful Quick Step you can create is to mark an email read with no flags or categories set. Using this Quick Step, you can clear everything from one email or using the combination of Ctrl/Shift you can select multiple emails to apply this action too. This Quick Step is best when using the Move Old Emails macro which is looking for complete emails to move out of your inbox.
Do you find yourself spending all this time creating the perfect email only to end up recreating it in the future? Stop reinventing the wheel over and over again! Outlook allows you create a drafted email and save it as an Outlook Template File (*.oft). Email templates help save time and allow you to send quicker responses.
When creating a new Excel workbook you will notice that you start with 1 or 3 already created sheets. You have the option to adjust how many sheets are created from a new Excel workbook. There are also additional options to change the default Font type and size. If you are currently creating additional sheets and adjusting the Font for every Excel workbook you create a couple setting adjustments here will help you save some time.
This tutorial will show you how to Set a Default Signature in Outlook. Setting up a Default Outlook signature is a standard setting in Outlook but there is more to this feature then you may realize. If you work with multiple Outlook accounts a Default Signature can be set for each Outlook account. You can also prevent your Default Signature from appearing on email reply and forwards.