calling outlook function that's in a different vbaproject.otm
Posted on 2009-05-12
I'm working on a computer that has more than one user. I'm trying to send an email from Access and have vba that instantiates outlook; Set myOlApp = CreateObject("Outlook.Application")
But, even if I have outlook open, myOLApp ends up referring to another instance of outlook (a different vbaproject.otm). For what I'm doing, the instance of outlook vb needs to be open, and since it's not, I'm getting error 438 (Object doesn't support this property or method).
thanks for looking and your suggestions