How to use Google App Scripts to send HTML emails from Google Sheets with Airtable Data

Whew!!! That is a long title! Also, I don’t demonstrate pulling data from Airtable in this video or code example. If you’d like that, check out my previous article on my client’s Airtable Reporting Dashboard using Google App Scripts, BigQuery, and Google Data Studio. The code to pull Airtable data is there. However, this is […]

Continue reading

Listing Excel Workbooks and Sheets from Microsoft Access using VBA

SUMMARY: Tutorial to show how to use Microsoft Access VBA to retrieve and display open Workbooks and their Worksheets. I create a lot of dashboards, reporting systems, and document automation projects built extensively using Visual-Basic for Applications. Often, the infrastructure looks like: Microsoft Access as a front-end application. SQL Server as the back-end data repository. […]

Continue reading

Mailmerge without using Microsoft Outlook uses only Excel, VBA, Word, and CDOSys

Summary: Send personalized emails to a list of email addresses and names in Microsoft Excel. Technologies used Microsoft Excel Microsoft Word VBA (Visual-basic for Applications) CDOsys (Collaboration Data Objects for Windows 2000) CDOSys Documentation It’s amazing how poorly documented it is.. but this link has some answers. https://msdn.microsoft.com/en-us/library/ms526318(v=exchg.10).aspx And Dan at Microsoft has several links: […]

Continue reading