469,950 Members | 1,391 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

Access/Outlook integration in Office xp/2003 ?


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.
Nov 12 '05 #1
1 3879
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.


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by PromisedOyster | last post: by
9 posts views Thread by prakashwadhwani | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.