Astro: Adding Previous and Next Post Navigation Links to Blog
Astro component adding relative navigation links to the previous and next blog post entries in a collection.
Blog
Excel VBA: Automate E-mail Content Extraction from Outlook
Custom VBA automation to extract information from structured e-mails in Outlook into Excel worksheet using both text-based and HTML table-based methods.
Excel VBA: Retrieving Outlook Address Book Values
Custom Excel VBA function to retrieve field values from an Outlook address book entry. Searches both local contacts and Exchange address books.
Astro: Collection Pagination Using Rest Parameter Dynamic Route
Astro pagination capability using collections and dynamic routes with a rest parameter. Resolves type issues and generates post listings with page navigation.
Power Query: Access REST APIs Secured by Basic Auth and API Key
Querying REST APIs secured by both Basic Authentication and API tokens, using Power Query. Anonymous instead of Basic authentication is used for the data source.
Power Query: Handling Paginated REST API Data
Multiple solutions for querying paginated REST APIs with known or unknown page counts or entry counts, using Power Query.
Power BI Map Visualizations: Mapping Continents and Countries
Display continents and countries using Power BI map visualizations. Country-level mapping is challenging due to geopolitical issues and inconsistent naming.
Power BI Map Visualizations: Mapping Common City Names
Accurately map common, non-unique city names using Power BI map visualizations by setting the correct data category and including country and coordinate data.
Why I Switched from WordPress to Astro
Switching from WordPress to Astro delivers improved performance, flexibility, and scalability at a reduced cost and with lower maintenance overhead.
Create Self-Signed S/MIME Certificates
Create self-signed S/MIME certificates to sign and encrypt e-mail for free using OpenSSL.
Starting Over: Rebuilding My Website Using Astro
Redesigning and rebuilding my website from scratch using Astro.