Classic Outlook v’s New Outlook

Classic Outlook v’s New Outlook

Classic Outlook v’s New Outlook

Classic Outlook v’s New Outlook

Why You Might Want to Wait Before Switching

Note: This blog post refers to Classic Outlook as the traditional M365 Outlook for Windows Desktop Client that has been a staple in business environments for many years

You may already be using the New Outlook or perhaps you have seen the ‘Try the new Outlook’ switch appearing in your Outlook Client. What is clear is that it will eventually replace the Classic Outlook, but the transition will be gradual. Microsoft plans to support the Classic Outlook for Windows until at least 2029.

Switch - Try the New Outlook

What is the New Outlook (Project Monarch)?

The New Outlook, previously known by the codename Project Monarch, aims to provide a unified experience across platforms (Windows, Mac, and web). It features a modern web user interface, improved performance, and better integration with M365 technologies like Teams, OneDrive, SharePoint, Power Automate, and Copilot.

This is not just an update to an existing product like we are used to when moving from Outlook 2016 to 2019 to 365, etc. This is a complete rebuild of the product on new technologies.

The big win for Microsoft here is that the different versions across all platforms (Windows, Mac) will be built upon a common codebase and design, making them much easier to manage and update. The big win for us users is that we will have a similar user experience across all our devices.

New Outlook Logo

Why Might You Hold Off Switching?

Well, a lot of us don’t like change, and in this case, with valid reason! Many key features from Classic Outlook are still missing in the New Outlook or are not quite the same as they were. This will change with updates, so keep an eye on this Microsoft comparison page.

However, two of the biggest issues are the lack of support for COM Add-ins and VBA scripting. These issues will never be fully resolved.

COM Add-ins: Classic Outlook supports COM add-ins for extensive customisation and integration with other software. This technology is incompatible with the New Outlook. Instead, the New Outlook uses Office web add-ins based on HTML and JavaScript. This means that some companies will likely release new versions of their add-ins over time, but many will not, particularly in the case of legacy systems.

VBA Scripting: VBA (Visual Basic for Application.) in Classic Outlook allows for task automation and is the gateway that allows integration with other custom-built Microsoft Office solutions. This technology is incompatible with the New Outlook. Instead, it seems the preferred method of automation going forward will be to use Power Automate. Many businesses rely on custom VBA tools built in the likes of Excel or Access that interact with Outlook, for generating automated emails, sending bulk mail merges, monitoring inboxes for certain mail items, and automatically setting up calendar events.

Conclusion

While the New Outlook offers new features and improvements, the loss of COM add-ins and VBA will be significant drawbacks for many. This will likely lead to many organisations sticking with Classic Outlook or rolling back in order to maintain their existing workflows and custom solutions.

On a side note, hopefully, they come up with a better name than New Outlook soon!

Olas's Application Development Team

Our Application Development team specialises in finding custom solutions for our clients. Over the years, we have both created and supported many Microsoft Office solutions that rely heavily on VBA or COM add-ins for Outlook. Going forward, we will continue to find new solutions to adapt to the challenges posed by changing technologies and to inform our clients of the implications of these changes.

 

Olas Team - Fergal

Fergal O'Connor

Senior Technical Consultant


fergal.oconnor@olas.ie
Mobile: +353 86 841 3708

MS Forms Integration in Excel Desktop App: A Game Changer for Data Collection

Blog - MS Forms in Excel

Exciting news for Windows Excel 365 users! MS Forms is now integrated into the Excel Desktop App, bringing two of our favourite M365 products closer together and streamlining the data collection process.

With this new feature, you can create and link an MS Form directly within an existing Excel workbook. This means that live-form response data can be accessed inside a related project’s workbook seamlessly. Users can now collect data via an MS Form, and the responses will feed directly back into their Excel workbook. From there, the data can be viewed and reported on, eliminating the need for manual data entry and consolidation.

This integration simplifies the process of transferring response data between files, making data management more efficient and less error-prone.

Getting Started

  • Save Your Excel File: Ensure your Excel file is saved to an online cloud location such as SharePoint or OneDrive.
  • Enable AutoSave: Turn on the AutoSave function.
  • Insert a New Form:
    • Go to the Insert tab
    • Select Forms > New Form.
Excel New Form Option

This will open a blank MS Form in a web browser window. From here, you can create an MS Form as usual. Once completed, you can submit a survey response. The response data will flow directly into the worksheet where you added the form. 

Sample MS Form
Sample MS Form Response Data in Excel

With an MS Form linked to your worksheet, you will find additional quick MS Form options available within Excel, allowing you to navigate quickly to your form without opening MS Forms separately:

  1. Preview Form
  2. Edit Form
  3. Send Form
MS Form options in Excel

Availability & System Requirements

This new feature is available to Windows Excel users using Version 2410 (Build 16.0.18227.20000) or later.

To check your version:

  • Go to File > Account.
  • If you are not on the latest build, you may be able to update it using the Office Updates section found in the same location.
Excel About - Version

Olas's Application Development Team

Our Application Development team specialises in finding custom solutions for our clients. MS Excel and MS Forms are two commonly used tools in many of our clients’ solutions, and this new functionality will only enhance our capabilities. This will lead to even better and more streamlined solutions.

Contact us today for assistance with creating an Excel or MS Form solution, or to discuss potential solutions for your projects.

Olas-Team-Fergal

Fergal O'Connor

Senior Technical Consultant


fergal.oconnor@olas.ie
Mobile: +353 86 841 3708

2025 Schedules Now Available!

2025

2025 Schedules Now Available!

Heading into the final quarter of 2024, Olas are here for all your training and development needs.  Book a course with us; we can customise and schedule on demand.  We can help you automate your processes and improve efficiencies in your day-to-day tasks – maximising the potential of your technology.

Whether you’re looking to book a course in the last quarter of 2024 or plan for 2025, we’ve got you covered. Keep an eye out for our new Co-Pilot and Power Platform courses!

About Us - Marta Maslowska Olas Business Development Manager

MARTA MASLOWSKA
BUSINESS DEVELOPMENT MANAGER


Mobile: +353 085 8006445