By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,466 Members | 2,482 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,466 IT Pros & Developers. It's quick & easy.

Access/Outlook integration in Office xp/2003 ?

P: n/a

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
Share this Question
Share on Google+
1 Reply


P: n/a
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.