Opening Outlook from Access...

[Jim Burke in Novi]

I asked this once and didn't get any responses so I'll try once more. I have
an access application that will be running on multiple workstations on a
network. One of those workstations will have the Access DB that has the
tables, which the application will be linked to, and will also have Outlook
running, being used as a central appointment scheduler. I want my Access appl
to be able to look at the Outlook appoitments, regardless of which
workstation they are running on. The way I have it set up right now Access
only looks at the Outlook that is running on the same workstation. How do I
connect to Outlook on a different machine? Here's how I am currently opening
my Outlook connection:

Set objOutlook = CreateObject("Outlook.Application")
Set outlookNS = objOutlook.GetNamespace("MAPI")

Any help is greatly appreciated!

 

[AutomationGuru]

Hi Jim ,

Try:
Set objOutlook = CreateObject("Outlook.Application",ComputerName)
where ComputerName is the name of the machine you want to connect to.

 

[Jim Burke in Novi]

I take it you mean GetObject. I thought the 2nd parameter was for documents,
but maybe it can be used for ComputerName. I'll give it a shot. Thanks.