[AccessD] OT Outlook

Martin,

In MS Access you can do:

Access.Application.COMAddIns(1).connect=True

To connect the first of registered COM Add-Ins.

I believe in Outlook it should be:

Outlook.Application.COMAddIns(1).connect=True

To identify the add-in you can cycle COMAddins collection and use ProgId or
Descriptin properties. Here is just debug.print cycling sample:

Dim myAddIn As Office.COMAddIn
    For Each myAddIn In Access.Application.COMAddIns
       With myAddIn
          Debug.Print "Connected = " & .Connect;
          Debug.Print " , ProgId = " & .ProgId & " - ";
          Debug.Print .Description
       End With
    Next myAddIn

To use this code you have to have a reference set to MS Office object
library - I expect it should be set in MS Outlook VBA by default...

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Wednesday, September 27, 2006 11:53 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] OT Outlook

How can I turn on a Com add in in outlook via code using VBA. The add in is
of by default. I dont know its name by the way (<:
 
Generics will do if anyone knows I can work it out from there.
 
Martin (wading about in the dark in Belfast)
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477