It was a Microsoft Word (VBA) application written back in 2001.
Essentially what it does is:
- user selects a letter type.
- the user then enters some customer reference numbers.
- the VBA application does an Oracle database lookup to convert those customer reference numbers into names and postal addresses.
- which the VBA then uses to “mail merge” into whatever number of letters need to be sent out.
And it was broken.
I had a feeling that writing about patch management policy would come back to bite me (and it did).