I don't think that you can do this, (but I'll be happy to hear otherwise,
myself) which I still find bizarre given that programs like Crystal
Reports can access the Outlook tables directly.
Regards
Peter Russell
Iain Miller previously wrote:
Currently using & developing a new application in A97. This app has a
lot of
Name & Address information in it. A lot of that information will be
duplicated in Outlook & I suddenly wondered if its possible under the
newer
versions of Office to use the information already stored in Outlook as
part
of an Access database project. The logic being that the data could then
be
held in one place rather than two. This is a customer & order management
application & so there is regular need to contact people whose data is
stored in the application.
So the question is as to how well can you integrate Access & Outlook in
newer versions of Office? Can you, for example, create an application
that
has tables (for things like Orders etc) linked to an outlook address
book as
if it were a table in the database? Obviously you'd have to have some
controls on the Outlook address book to ensure data didn't get
removed/altered/deleted but otherwise it might seem an ideal thing to
be
able to integrate & would save a load of aggravation in duplicating data
entry (i.e. having to enter all of the details for a new customer into
an
Access Application and then entering them into an outlook address book
as
well.
rgds
I.
