linked contacts with Outlook- store more info in Access 1

[Achmed]

Hi everybody,

Here's what I'm trying to do (with office 2003): I'm creating a database for storing information associated with various contacts. The contacts are in already in Outlook, so I linked to the Outlook contact table, which works fine (want to use Outlook for the emailing portion of this project and Access to store and report on additional information). What I need to do is have a second table, for example, that stores more detailed information about these contacts. The Outlook table has no nice little autonumber style primary key, so I can't figure out how to link these tables. I'm going to create a form that shows information from Outlook combined with fields from the new table. Any ideas?

Thanks in advance.
-Alan

 

[Remou]

Hi
User Defined Field (Outlook 2k)? Telephone? Email?

 

[Achmed]

User defined fields won't do in this case- I need to store more information than that.

 

[Remou]

Sorry, should have explained what I meant. Is it viable for you to add a user-defined field to each Outlook Contact that would store an ID number for linking? Alternatively, have you considered a telephone number or email address as a linking field?

 

[Achmed]

Ah... your momma didn't raise no fool

Ideally, Outlook would create an AutoID for me- any way to do that?

Thanks for the help!

 

[Remou]

Have a look at this:

http://www.outlookexchange.com/articles/home/microsoft06.asp