Link outlook 2003 contacts with access 2003 database

  • Thread starter Thread starter Corne
  • Start date Start date
C

Corne

I have a contacts database in access with a unique
primary for each of my clients that is linked to other
tables. I have the same contacts and some additional
contacts in outlook 2003. Maintaining these 2 different
data sets is a error waiting to happen and I would like
to have only one contact list with unique primary keys
sothat I can still use my database tables for these
contacts. How do I merge the two contact lists sothat I
only have one contacts data base to maintain?? Ps. the In
Access the > File> Get External Data> Link Tables
function does not cater for primary keys or allow for the
table to be changed?? What shoul I do?
 
Access can directly talk to Outlook if the mail server is an Exchange
server, using a 128 character GUID (Globally Unique Identifier) string
generated by Exchange. The code to do so is not trival though.

I have some code on my website to send mail from Access, using Outloook as a
mail client, so that you can maintain the contacts in Access. You can also
import Access data into Outlook and map the fields as desired. That option
is right on the Outlook file menu.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top