Linking table to outlook contacts.

  • Thread starter Thread starter Steve_work
  • Start date Start date
S

Steve_work

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.
 
Hi Steve!
One way I could suggest, thou it may not be perfect solution for you is:
1. In the database you have created, create a link take, and link it to
Outlook address box, using exchange when you are promted for to link.
2.create a append query to append to the linked table from your main table
where ever you add a record to the main table, you need to run the append
table to update your outlook address book.
I dont have idea you would delete a record
 
Hi Sinmi, thanks for the suggestion. If I understand this correctly you are
suggesting adding data into the new empty database table by running an
append command whenever I add new records to the exisitng table. If this
correct then doesn't this mean that I will have two versions of all records?

Is there a way for me to tell access to link the firstname field in table 2
to the firstname field in table 1 for example, so both fields in the two
different tables link to the same data?

steve
 
Back
Top