[AccessD] OT Outlook

Thansk Shamil
 
I have 6 add ins showing up in outlook
 
Microsoft Access  Add in for data collection (This is the one I am interested in)
Microsoft Exchange Oulook add in
SharePoint Addin
Outlook Mobile Service
VBA for Outlook
SnagIt Add in (Graphic Package we use)
 
But I think I can sort it now thats to you example
 
Thanks and Best Wishes
 
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: Thu 28/09/2006 09:49
To: 'Access Developers discussion and problem solving'
Subject: Re: [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/>  <http://www.databaseadvisors.com/>



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