[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/>