Solved

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

Posted on 2009-05-12
5
242 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

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.
When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

752 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