473,568 Members | 2,988 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4055
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

47
4485
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!
1
3321
by: com | last post by:
Extreme Web Reports 2005 - Soft30.com The wizard scans the specified MS Access database and records information such as report names, parameters and subqueries. ... www.soft30.com/download-1-11975.htm - 31k - Cached - Similar pages MDBSecure 1.0.8.0 - Soft30.com Utility which makes it easy to create secure MS Access Databases, ... MS...
4
5090
by: Max | last post by:
Hi, I would like to have a button and a combo box with options to select various versions of Microsoft Outlook: 2002, 2003. The user selects the email client and clicks the button. The only things happening will be: a new email is created and some text is placed in the body, then the email window is displayed. The user can close the window or...
2
703
by: Gerhard | last post by:
I would like to integrate Outlook into my vb.net web page, so that when I send an email (which I can successfully do now), it shows up in the sender's Outlook Sent Items. How do I do that? Thanks.
5
1544
by: Pieter | last post by:
Hi, I have a VB.NET (2.0) application that integrates with Outlook 2003. I have windows XP SP2. The users had Windows 2000, and Office 2000. They upgraded (!) to Office 2003. But: - an action that takes 0,5 seconds on my pc, takes them 4-5 seconds - an action that takes 2,5 seconds on my pc, takes them 8-9 seconds
3
2248
by: ARC | last post by:
Hello All, I have a major application for quoting and invoicing that is written in Access 97 (both front and back ends). I have a user base of over 300 customers, and currently I don't require that they have Access 97, as I use the access 97 runtime scripts from Sagekey software. The main problems I've seen with Access 97 are the built in...
14
2761
by: ARC | last post by:
Hello All, I have a major application for quoting and invoicing that is written in Access 97 (both front and back ends). I have a user base of over 300 customers, and currently I don't require that they have Access 97, as I use the access 97 runtime scripts from Sagekey software. The main problems I've seen with Access 97 are the built in...
1
1733
by: PromisedOyster | last post by:
We have a written a C# application that interfaces with Outlook using the API. Since Microsoft Office 2000 SP1, our users have had to put up with the very annoying warning popup about a program accessing Outlook and do they want to allow/deny. However, since migrating many of our users to Office 2007, some (not all) of our Office 2007...
9
4482
by: prakashwadhwani | last post by:
Hi !! I'm about to develop a new project for a client. Should I go about it in Access 2003 or 2007 ? Purchasing it either for me or for my client is not a major consideration here ... what I'd like to know is the stability, speed & ease of use of both the products. I believe Access 2007 has a new file format too and that it may be...
0
7601
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
1
7659
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7962
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6274
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5217
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3651
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3631
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2099
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1207
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.