Solved

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

Posted on 2009-05-12
5
240 Views
Last Modified: 2012-05-06
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
0
Comment
Question by:avoorheis
  • 3
  • 2
5 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 24366896
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
 

Author Comment

by:avoorheis
ID: 24367106
accessing the one in another profile
0
 

Author Comment

by:avoorheis
ID: 24367117
actually, Access is accessing another profile than the currently logged in user.
0
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 24367232
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
 

Author Comment

by:avoorheis
ID: 24367406
thanks
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question