Linking with Contacts from Outlook

  • Thread starter Thread starter Scott Viney
  • Start date Start date
S

Scott Viney

Morning All,

I have all my contacts in Outlook and dont wish to create all this data
again in Access. So I have linked my data base to this data in Outlook.

The problem is there is no primary key when you link to these contacts. I
need like a CONTACTID key in this data so I can create my relationships.

What does everyone else do?? Or how can I do it?

Cheers,
Scott V
 
Yes this is a major problem for outlook,

the solution I used, create a custom field within the contact form
(Outlook), called Contact_ID, use VBA to talk to your database to get the
next Contact_ID number so that they are linked, the problem here is Access
is a relational database and Outlook could not be more different,
unstructured etc. Create a Contact Table in the Access database to hold the
Contact_ID and maybe some other information sync'd one way from the Outlook
contact form so that you don't have to query Outlook for everything.

Hope it helps.
 
Scott said:
Morning All,

I have all my contacts in Outlook and dont wish to create all this data
again in Access. So I have linked my data base to this data in Outlook.

The problem is there is no primary key when you link to these contacts. I
need like a CONTACTID key in this data so I can create my relationships.

What does everyone else do?? Or how can I do it?

Cheers,
Scott V
Click to expand...
One way would be to export your contacts. File>Import and Export,
when the wizard pops up chose export and for file type select
Access and chose a location. This will create an Access database
containing your contact info.

gls858
 
Alex,

Thanks for the help and ideas. I can add a custom field in Outlook no
probs. Not too sure about doing the VBA stuff.

Also what do you mean maybe some other stuff? What all the data from
Outlook? And how do I sync it one way... does that mean that it can only be
changed from the Outlook side? That would be better.

Can you post an example?

Have a good one,
Scott V
 
Back
Top