Linking table to outlook contacts.
- From: "Steve_work" <nospam@xxxxxxxxxx>
- Date: Thu, 2 Mar 2006 10:00:08 -0000
Hello.
I'm not sure if this is the right group to post this but here goes.
I've created a simple access database that contains a table that lists all
the members of staff in our building together with their email address and
telephone number and a few other details.
What I would now like to do is link this table into Outlook 2003 so that
each member of staff appears as a contact. I've created a new empty contact
folder in Outlook ready to receive this data. The idea being that when new
staff join/leave I can just update the database and the contacts in Outlook
will be updated as well. I've used the option get external data -> link
tables in Access and I can select the empty contacts folder from Outlook and
it opens a new table in Access complete with all the field names. If I
manually enter data into these fields they appear in Outlook. Now this is
where I'm stuck. I don't want to duplicate data across two tables, I want to
link the fields I want from my main access table into the this linked
outlook table. There seems to be a lof of fields within the outlook table
but I just need to use a few fields, i.e. names, email etc. Any idea how I
can do this?
One final note, I'm not an advanced Access user, so I hope it doesn't
involve writing pages of SQL script.
.
- Prev by Date: Re: Using Microsoft Query with Access via Import External Data?
- Next by Date: Re: tables that are linked are not getting updated
- Previous by thread: Re: how to get .txt data into access constantly
- Next by thread: Re: Linking table to outlook contacts.
- Index(es):
Relevant Pages
|
