Excel email: Outlook not recognizing email ID

maybe add

        .Recipients.resolveall

before the .Send line

Joseph,
I was very excited to get your post, because I was sure that was going to solve all my problems, but no such luck. The added code didn't seem to help at all. BTW, I noticed in my code posted above that I neglected to note that I have "Option Compare Text" at the top of the module.