I once built a program with MS Access that handled a mail merge job of ~1000 letters per week. It used a very simple word template. For input, every Friday, I pulled data from a production SQL database which I saved to an Excel spreadsheet. I built an import function that loaded the Excel data into table in my MS Access tool. The program ran a mail merge process for all … [Read more...] about Automatic Mail Merge With VBA and Access
Archives for November 2015
Send Email Through Outlook with VBA
I have to say that I have been super hesitant to share this example as it could be used by spammers. That being said, there are plenty of legit uses for sending email through Outlook with VBA. I have used this function primarily to automate the delivery of scheduled reports where I pull in an HTML template (fancy), replace template "placeholders" and have the report sent to a … [Read more...] about Send Email Through Outlook with VBA
VBA Control Naming Conventions
It is always helpful to use thoughtful naming conventions for controls when working on a VBA project. This is especially true for when you need to open an old project to see what is going on, or when someone else needs to work on your project in the future. Everybody does this differently, but I follow naming conventions that I learned back when I learned VB 6. Basically … [Read more...] about VBA Control Naming Conventions
MS Word Document text to String with VBA
I once had a project where I had to work with a large directory of unsorted word documents. The main directory had a deep sub-directory where there were multiple versions of the same document with the same file name. It was a mess. Basically, my responsibilities were to pull out unique document filenames with the most recently modified version and parse each document for a … [Read more...] about MS Word Document text to String with VBA
Connect to MS Access Database with Javascript | HTA App
This one is a work in progress. The end goal is to build an easy scaffold for users to quickly build an HTA CRUD interface that connects to an MS Access database. For those of you who don't know what an HTA application is, you can read a very high level explanation here: https://en.wikipedia.org/wiki/HTML_Application HTA is wildly out of fashion. Most people don't know what … [Read more...] about Connect to MS Access Database with Javascript | HTA App