[AccessD] OT Outlook

<<<
Just repeats the same add in over and over
>>>
Hello Martin,

Does it mean that you have more than two Outlook Add-ins installed?
Do you have "COM Add-ins" menu entry under "Tools" menu bar? (If not - you
can put it there by using Right-Click->Customize... (it's "buried" in Tools
commands))
When using Tools->COM Add-ins how many COM add-in do you see in the list?

As far as I see there are only two:

1. Connected = False , 
    ProgId = AceCnfViewer.sortie - 
             Microsoft Office 12.0 
             Access Database Engine 
             Conflict Resolver
2. Connected = False , 
    ProgId = CnfViewer.sortie - 
            #401

To programmatically from VBA code activate the first one this code line
should be enough:

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

To activate AceCnfViewer.sortie add-in in the case it's not the first in the
list this code can be used:

Option compare text
...
Dim myAddIn As Office.COMAddIn
    For Each myAddIn In Office.Application.COMAddIns
       With myAddIn
	    If .ProgId = "CnfViewer.sortie" then
             .Connect = True
             Exit for 
          End if 
       End With
    Next myAddIn

--
Shamil
 

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

Shamil
 
Just repeats the same add in over and over
 
Connected = False , ProgId = AceCnfViewer.sortie - Microsoft Office 12.0
Access Database Engine Conflict Resolver
Connected = False , ProgId = CnfViewer.sortie - #401
 
 
Its Access 2007. What I am doing is trying to set the Data Collection Email
add in in Outlook to true. It is off by default. Data Collection is a wizard
activity but you can code it. In order to code for it you need to set the
com add in in OUtlook 2007 to on. It is turned on when you first run the
wizard.
 
Sort of feeling my way in the dark here are com add ins are out of my area.
 
Also have to create XML on the fly as well. Still havnt worked that bit out
yet either (<: but it is interesting.
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Shamil Salakhetdinov
Sent: Wed 27/09/2006 21:33
To: 'Access Developers discussion and problem solving'
Subject: Re: [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



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>