Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2009-05-12
5
Medium Priority
?
248 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 2000 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

824 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