I'm writing an Excel program to generate emails for a coworker. It works alright for me, but right at the beginning when he gets to


Set ool = GetObject(, "Outlook.Application")


...it fails for him, "type mismatch" error. He's in Michigan, I'm in NC, so it's impractical for me to run over to his desk to see what's going on. He tells me a copy of Outlook ~is~ running. His Tools / References are the same as mine. I tried getting him to change that statement to


Set ool = CreateObject("Outlook.Application")


...but it just said it couldn't create the object.




I'm not sure even what questions to ask. What ~could~ cause it not to be able to find a copy of Outlook? I'm pretty well convinced that there is something basic I've misunderstood about GetObject and/or CreatObject that would clear this up for me, but I can't see what it might be.