ricketyshack.ca/blog

More Adventures In Powershell

After running into a number of stumbling blocks and hassles trying to get scripts interacting with an MS Access database, I was able to get what I wanted. Ultimately, the project I had in mind doesn't make a lot of sense to implement at this time, so I shelved it and I can appreciate the learning experience for what it was.

I ended up moving on to using scripts to read my Outlook inbox and generate reports and summaries. As part of my job, I receive a lot of automated messages so this will prove very useful. I was also able to find a lot better guidance and examples for what I was looking to do, albeit not all in one place. (And, of course, I had to avoid irritating, AI-generated websites clogging up my search results.)

I am still debating the possibility of buildin a small website to hold my notes and some examples of the scripts I've been writing. The exact scripts I am using are very purpose-built, but the concepts behind them are also fairly straight-forward. It would probably serve me well to go through the process of writing out public-facing examples, to refine my approach and code.

All this is to say: I've learned to appreciate the capabilites of Powershell even more than I did in years past. It's letting me do a lot of things without having to argue with IT and make a case for installing Python on my workstation.

PUBLISHED: 2026-06-19

Back to top »