calling outlook function that's in a different vbaproject.otm

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).
Any ideas?
thanks for looking and your suggestions
avoorheisAsked:
Who is Participating?
 
David LeeConnect With a Mentor Commented:
That's a problem.  Outlook can only see the vbaproject.otm file in the current profile.  I t cannot see or use one from another profile.
0
 
David LeeCommented:
Hi, avoorheis.

There is only one copy of vbaproject.otm per Windows profile.  Are you saying that Outlook is accessing one from another Windows profile, or are you saying that you have more than one in your profile and it's accessing the wrong one?
0
 
avoorheisAuthor Commented:
accessing the one in another profile
0
 
avoorheisAuthor Commented:
actually, Access is accessing another profile than the currently logged in user.
0
 
avoorheisAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.