AEU Meeting Date 4 June 2025 starting at 18:00 UK Time (UTC+1)                     Last Updated 26 July 2025



Meeting Details:

This Access Europe meeting will be on Wednesday 4 Jun 2025 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM)

The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST

Please note that the UK is currently on Summer Time (UTC+1). For local times, please check World Time Buddy

We use Zoom as our meeting application. Please click this link to Get Zoom if you don’t already have it.

When the time comes for the meeting, please use the following link: Join Zoom Meeting
If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210

For more connection options, please see the AccessUserGroups.org web page for this event

All sessions are recorded and later uploaded to the Access User Groups channel on YouTube

If you do not wish to be part of the recording, please ensure your webcam and microphone are both switched off during the meeting.



Download Outlook Calendar (.ics file):

Click to download. Save in Outlook to create a recurring event for each month:       Outlook Calendar (.ics)



Topic outline:

In today’s data-driven world, database solutions must do more than store records: they need to deliver actionable insights, high-quality documents, and dynamic presentations at the click of a button. In this session, you’ll discover Advanced Office Analysis & Automation (AOAA), a proven framework that empowers Microsoft Access to coordinate seamlessly with Excel, Word, PowerPoint, Outlook, SharePoint, and SQL Server — leveraging each application for what it does best while sharing data fluidly between them.

In this session, Domenico Ruggiero will be discussing multi-app solutions that involve Access and SQL Server as a foundation for serving up exports to Excel / PowerPoint / Word.

Why Attend?
•   Real-World Case Study:
      Explore the CSI Cost Management Report Automation, where a weekly, 4–5 hour manual process for 40–50 projects (later over 150) was transformed into a fully automated workflow named
      "Rod-Bot". Using an Access front end connected to SQL Server and templated Excel workbooks, each of 160+ reports is generated, validated, and queued with progress notifications,
      thereby freeing stakeholders to focus on analysis instead of assembly.

•   AOAA Principles:
      Learn how to apply modular, reusable VBA-driven logic and proven methodologies to orchestrate multi-app solutions that adapt as your inputs and requirements evolve.

•   Technical Deep Dive:
      See best practices for:
      o   Configuring Access to work with templates with a non-coder stakeholder’s flexibility to make changes.
      o   What standardized templates look like in Excel, Word, and PowerPoint.
      o   VBA code for building batch distributions of emails and attachments through Outlook.
      o   A custom email notification (UI based) for Access checking for unread Outlook inbox emails.

Who Should Attend?
Access developers, Office power-users, and IT professionals eager to elevate their applications beyond standalone silos — leveraging the full Microsoft Office ecosystem to deliver richer, faster, and more accurate solutions. Join this Orchestrating Office presentation and walk away with actionable techniques to harmonize your Office applications, turning disparate tools into a cohesive, productivity-boosting symphony!



Background Info:



Domenico Ruggiero (AKA The Software Maestro) is a high-performing, ambitious and self-motivating individual with a B.A. in Aerospace Engineering from the University of Florida and an M.S. in Industrial Engineering with an emphasis on Engineering Management from the University of Central Florida.

He has over 20 years of experience in engineering, project management, operations, and software development with a history of repeatedly implementing analytical methods, automation scripts, and innovative integrated solutions for NASA programs and many other clients.

Domenico possesses a powerful combination of business and operations experience, a strong educational background, and an analytical mindset.
In recent years, he has become an expert in the development of advanced VBA-enabled, customized analytical models and data automation tools using many of the MS Suite of products.

Website: Meet the Software Maestro | the-software-maestro



Download:

Click to download a PDF of the presentation used in this session:     Orchestrating Office: Amplifying Access with Multi-Application Automation     PDF file     (Approx 6 MB)

Updated versions of all other files used in the presentation are now available from Domenico's website: Access User Groups - Orchestrating Access     ZIP file     (Approx 80 MB)



Video:

The meeting was recorded and the video is now available on the Access Europe YouTube channel at https://youtu.be/ZXtxh63d-fg or you can click below:

       

Mike Wolfe has now written a summary of the main points arising from this video. This is available on his NoLongerSet website:Orchestrating Office with Domenico Ruggiero



Colin Riddington           Mendip Data Systems                 Last Updated 26 July 2025

Return to Access Europe Page

Return to Top