Troubleshooting VBA Error on Code to Extract .msg File Metadata

This is a response to a Litigation Support Tip of the NIght visitor who had a problem with the VBA code discussed in the Tip of the Night for March 31, 2018. I re-tested the code tonight, following the steps discussed in the post, and was able to successfully extract metadata from a set of .msg files. The visitor claims that he got an error message reading: "Type mismatch" error when trying to run the Visual Basic code.


This error could result from one or two different mistakes:


If you neglect to check off the Microsoft Object Library in Tools . . .. References as discussed in the first step of this tip, you will get this error:



If the folder holding .msg files to be processed does not have any .msg files, this error will be returned: