Solved

opening outlook calendar from access form

Posted on 2008-10-29
10
576 Views
Last Modified: 2013-11-27
I'm no longer going to preface questions with "is it possible" - cuz I now know that almost anything is!! what I need to know now is how complicated would it be to open ms outlook directly to the calendar from a command button on an access form; and, would this be possible on a multi-user (splid) database environment where it would be difficult to modify each user's version of access or outlook (supplying files would not be hard because i have front-end updater software that could deliver it... but modifying settings within office apps would not be so practical) thanks!!
0
Comment
Question by:jpomerantz
[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
  • 5
  • 5
10 Comments
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 22830834
Hi, jpomerantz.

It's not hard at all.  The code below opens the default calendar.  Add the code to a button's click event and you should be in business.
Const olFolderCalendar = 9
Dim olkApp, olkSes, olkFolder
On Error Resume Next
Set olkApp = GetObject(,"Outlook.Application")
If TypeName(olkApp) = "Nothing" Then
	Set olkApp = CreateObject("Outlook.Application")
	Set olkSes = olkApp.GetNameSpace("MAPI")
	'Change Outlook on the next line to the name of the default mail profile'
	olkSes.Logon "Outlook"
Else
	Set olkSes = olkApp.Session
End If
Set olkFolder = olkSes.GetDefaultFolder(olFolderCalendar)
olkFolder.Display
Set olkApp = Nothing
Set olkSes = Nothing
Set olkFolder = Nothing

Open in new window

0
 

Author Comment

by:jpomerantz
ID: 22832583
WOW!! that is so cool :) I can't thank you enough!!! for some reason though, it opens the calendar - but only if outlook is already open. if outlook is not open, nothing happens.  is there something to add to it to get it to first open outlook?
0
 
LVL 76

Expert Comment

by:David Lee
ID: 22832729
I included code to open Outlook if it isn't already open.  That's the code between the IF and ELSE.  Did you change the profile per the comment in the code?  Your profile may not be called Outlook.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:jpomerantz
ID: 22833193
I didn't change anything in it - just cut and pasted it... I'm sort of a newbie and don't know about profiles... how do I know what my profile is? I do know that the school has it's own exchange server - I remote in using a vpn but most users will be on the network in the building... is there a way to figure out what the profile should be?
thank you so much!!
0
 
LVL 76

Expert Comment

by:David Lee
ID: 22834540
Here's how to check your profile name.

1.  Open the control panel
2.  Double-click the Mail icon
3.  Click the Show Profiles button
4.  Look at the "Always use this profile" selection at the bottom.  The name you see there is the name of the default profile.  It's typically "Outlook", but could be soemthing different.
0
 

Author Comment

by:jpomerantz
ID: 22834854
sure enough, the profile does say outlook... I wonder what is going on. I tried this on two computers and it's the same thing: if outlook is open already, the code opens the calendar - but if it's not - nothing happens.  any ideas?
I really appreciate this!!
0
 
LVL 76

Assisted Solution

by:David Lee
David Lee earned 500 total points
ID: 22836974
Replace line #5 with the line below

If TypeName(olkApp) <> "Application" Then
0
 

Author Closing Comment

by:jpomerantz
ID: 31511118
Works perfectly now!!! thank you so so so much :-)
0
 

Author Comment

by:jpomerantz
ID: 22839329
that did it! I can't thank you enough :-)
0
 
LVL 76

Expert Comment

by:David Lee
ID: 22839338
You're welcome.  Glad I could help!
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

697 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