Exposing an Access Table in Outlook

[cglisc]

Hello,

This could be an outlook question, but here it goes anyway:
I have a Payroll application with an Employee table, which
I would like to expose into Outlook as a contacts folder.
I need this to be in real time, ie, changes to
contacts in ACCESS automatically refresh in Outlook. Something like attaching the table to Outlook.

The reverse, (changes in Outlook automatically reflecting
in the MS access database) is not that important.

Is this possible at all? Or only COM code will save me?

Thanks,
Chris Lambrou.

 

[PWise]

outlook folders can be linked to access
file menu--> get external data --> files of type
now, if your out look contact folder has all the fields you need in access drop your Employee table and just use outlook folder if you need your Employee table for fields that outlook dose not have write code to update your outlook folder such as if you want to add a new contact to outlook when you add a new Employee on the after update event of the new Employee form
docmd.runsql "insert into contacts (lastname,firstname,...)
select " & me.lastname & " as expr1 ," & me.lastname & " as expr2.....