Troubleshooting VBA Error on Code to Extract .msg File Metadata
top of page

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:



Sean O'Shea has more than 20 years of experience in the litigation support field with major law firms in New York and San Francisco.   He is an ACEDS Certified eDiscovery Specialist and a Relativity Certified Administrator.

The views expressed in this blog are those of the owner and do not reflect the views or opinions of the owner’s employer.

If you have a question or comment about this blog, please make a submission using the form to the right. 

Your details were sent successfully!

© 2015 by Sean O'Shea . Proudly created with Wix.com

bottom of page