473,473 Members | 2,032 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Outlook automation from Access?

The below code opens the Outlook calendar:

Dim mOutlookApp As Outlook.Application
Dim mNameSpace As Outlook.Namespace
Set mOutlookApp = New Outlook.Application
Set mNameSpace = mOutlookApp.GetNamespace("MAPI")
mNameSpace.GetDefaultFolder(olFolderCalendar).Disp lay
Set mNameSpace = Nothing
Set mOutlookApp = Nothing

But I can't figure out...

** how to refresh the calendar when it opens

appointments can take up to 30 seconds to appear when added with code from
Access

** how to limit the number of calendars open

I want a separate instance of the calendar open if Outlook is already open,
and a new instance if Outlook is not already open. So I think that means I
want to limit the instances to two... perhaps something like this:

Set objCals = GetObject(, "Outlook.Application")
If objCals > 2 Then Exit Sub 'how to enumerate object instances?

Thanks in advance...
Nov 12 '05 #1
0 1299

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: MLH | last post by:
Is the following remotely correct? =DDE("C:\Program Files\Program Files\Outlook Express\OEmig50","Attachment","Name") I'm not sure that OEmig50.exe is the executable for OE. Anybody know? ...
1
by: Dave | last post by:
I want to be able to check my inbox in outlook for an email with a certain phrase in the 'subject' and then when found open and save the attachment to my c: drive. Can anyone help me with the VB...
2
by: Salad | last post by:
A2003, WinXP I know it is possible to link the Outlook contacts table to Access. Is it possible to call/open the Outlook Contacts window form within Access?
2
by: Giganews | last post by:
I am currently working on an Outlook automation module in an Access 97 database. All is working well except now the client wants the generic email body to contain certain sections in red text and...
2
by: lauren quantrell | last post by:
Ok, so maybe this is way off the wall...and I realize this is more of a MS Windows question than an Access question, but here goes... Is there a way to grant an Access application itself admin...
10
by: John | last post by:
Hi When I open a new outlook email from vb.net, sometimes outlook is very slow to appear or occasionally outlook freezes completely. I am targeting mixed office2000/xp environments so I am...
14
by: Gerhard | last post by:
I'm posting this again, as no answer to the first post.... I would like to integrate Outlook into my vb.net web page, so that when I send an email (which I can successfully do now), it shows up...
26
by: Tom Becker | last post by:
Is there a way, from Access, to programmatically click the Send and Receive button in Outlook?
5
by: Arno R | last post by:
Hi all, I need to get at specific (shared) agenda-data from MS outlook 2003. I need every day to get the scheduled 'appointments' for some rooms to Access. In Access I will show the...
1
by: Neil | last post by:
I have some code I use to create a mail message in Outlook 2003 from Access as follows: Dim objOutlook As Outlook.Application Set objOutlook = New Outlook.Application etc.... The code works...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.