Opening Outlook from Access...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi Jim ,

Try:
Set objOutlook = CreateObject("Outlook.Application",ComputerName)
where ComputerName is the name of the machine you want to connect to.
 
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.
 
Back
Top