Quote Originally Posted by jayplus
Thanks for the help so far.

I don't see anything in my available references that is called "VBA..." but I do see something called "Visual Basic for Applications" and in fact, one of them is already checked, but when I scroll down the list, I see another 5 items on the list with the same name, "Visual Basic For Applications". Could it be that I have the wrong one checked? Should I just go ahead and check them all?

As far as the "Missing" idea goes, you are right. There is one referenced called "MISSING: Microsoft CDO for NTS 1.2 Library". So if this reference is in fact missing, how do I go about installing it and refreshing the reference? Could ths CDONTS 1.2 library be causing my MID$ compilation error?

Thanks for helping out this newbie.
About Mid$. Try using VBA.MID$ in your code. Sometimes VB gets confused.