Blog

Custom VBA automation to extract information from structured e-mails in Outlook into an Excel worksheet using both text-based and HTML table-based methods.

Custom Excel VBA function to retrieve field values from an Outlook address book entry. Searches both local contacts and Exchange address books.

Astro pagination capability using collections and dynamic routes with a rest parameter. Resolves type issues and generates post listings with page navigation.

Learn how to query a secure REST API with Power Query using API keys and authorization headers for proper authentication.

Multiple solutions for querying paginated REST APIs with known or unknown page counts or entry counts, using Power Query.

Display continents and countries using Power BI map visualizations. Country-level mapping is challenging due to geopolitical issues and inconsistent naming.

Accurately map common, non-unique city names using Power BI map visualizations by setting the correct data category and including country and coordinate data.

Switching from WordPress to Astro delivers improved performance, flexibility, and scalability at a reduced cost and with lower maintenance overhead.

Step-by-step guide using OpenSSL to create a certificate authority and self-signed S/MIME certificates to sign and encrypt e-mail for free.

Redesigning and rebuilding using Astro for a simpler, static website to reduce maintenance overhead while improving control and performance.