How to use this VBA procedure to reset Outlook view settings each time you launch


Regardless of why you lose your favorite Microsoft Outlook view settings, it’s easy to reclaim them with this simple macro.

Reset Word In Wooden Cube

Image: SinArtCreative, Getty Images/iStockphoto

Microsoft Outlook is extremely flexible with its view setting–not only can you control what you see, or don’t see, you can create several views. That way, you can switch between views that support your different work tasks.

With all that viewing going on, you might end up with obscure settings when you launch Outlook the next time. That means before you can start working, most likely, you’ll spend time resetting things. You could easily reset the view or, by using a simple macro, you can guarantee that Outlook starts with the view you want to use when you start working. This is also a good idea if you support users who are easily confused by random settings and options. 

I’m using Outlook 365 on a Windows 10 64-bit system, but this will work in older versions. You can download the ThisOutlookSession.cls file and import it into Outlook rather than entering the code yourself. Don’t try to paste the code from this web page–the Visual Basic Editor (VBE) won’t be able to run it correctly. VBA code won’t run in a browser version.

LEARN MORE: Office 365 Consumer pricing and features

How to reset your security macro settings 

Out of the box, Office 365 is protective and disables all macros. Before you can run a macro, you’ll need to reset your security macro settings unless you’ve already done so. Follow these steps to reset your security macro settings.

  1. Click the File tab, choose Options, and then click Trust Center in the left pane.
  2. Click the Trust Center Settings button in the Microsoft Outlook Trust Center section.
  3. In the left pane, click Macro Settings.
  4. In the Macro Settings, click Notifications For All Macros (Figure A). At a later date, you might want to change…



www.techrepublic.com