Access / Exchange /Outlook Interfaces? Can I.......................

[COPA]

We currently use Microsoft Databases to handle Support Calls for work allocation and scheduling and progress checks . This links into other Databases for Asset registers , User Information , Maintenance contract calls , Network Events amongst other things.

Is it possible to configure the Database to link into Exchange and MS Outlook to dynamically create and update Outlook Tasks .
(My company does not have funds for a fully functional Help Desk System , and I would like to use in house skills if possible)

Please excuse me for this high level approach as I am not an experienced D/B admin or developer , but am looking to improve our work scheduling and progress checking by using our database for recording.

A simple yes , and references to case studies or help sites would be great at this stage.

Thanks
Paul C.
s-)

 

[sjn]

Yes.

I have created an application which directly links to Outlook from MS Access for scheduling appointments. I don't have the code handy at this point, but you would need to refer to OLE and automation application documentation in Microsoft.

If you need more assistance, just let me know and I'll try to get some specific examples for you to use and try.

Scott.

 

[COPA]

Thanks Scott, so long as I know its possible for now. I'll take a look at the Documentation you advise and then work on a design. Was the code VB ? Paul C.
s-)

 

[sjn]

Yes.

Set References to Outlook while editing a module, Tools -> References. Select Microsoft Outlook #.0 Object Library.

In a module procedure place the following statements.

Dim objapp as Outlook.Application

Then open the object browser that experiment with the appropriate functions for each item that you want your program to link. Once you get past how the objects are connected and can navigate through the appropriate methods, linking the data to the items in Access can then become very visible to the user in each of the applications.

This should get you started in the right direction.

Scott.