Solved

opening outlook calendar from access form

Posted on 2008-10-29
10
538 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
  • 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
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.

 

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

810 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