Unique Identifier

[Brent]

Hi folks,

I'm not sure if this is the right category; I am linking a specific folder
from Outllook into Microsoft Access. The db I'm using is to keep track of
staff inquiries and I have linked a folder from Outllook to the db so that I
can keep notes on the inquires as they come in by e-mail. What I need from
Outlook is the ability to show the unique identifier in the linked table. I
know how to put it on the form, however I can't seem to publish that form in
the correct folder. Secondly I'm not sure that would work. If I alter a form
to reflect the unique identifier, will it show on the linked table in Access.
If I can do that I can do the rest in Access.

Alternaitivly, if anyone has a suggestion on how to make an e-mail unique,
that would be appreciated too!

Thanks,

Brent

....but its summer holidays, I shouldn''t be learning!

 

[Chris O'C via AccessMonster.com]

I'll admit my ignorance with Outlook, but with linked tables you can't add or
enforce a primary key or unique index. You have to import the data from
Outlook into a table, and then you can assign your own primary key.

Once you import the data, you may be able to create a unique index on
multiple columns: sender, subject, date/time sent, date/time recieved, and
message size. But it's not guaranteed that a sender won't send two messages
with the same subject and byte size at the same time (to the second) and both
messages are received by the recipient at the same time (to the second).
It's only highly unlikely.

You'd have to periodically import new messages from Outlook to add to the
table to keep it up to date.

Chris
Microsoft MVP

 

[Pete D.]

You might post in the MS Outlook newsgroup as exposing what you need in
outlook will probally be your biggest challange.
This page might help you get started. Duff
http://www.outlookcode.com/article.aspx?id=25

 

[wphx]

check out the EntryID property in the outlook items

initially it seems to be about a 40 character alphanumeric code which
outlook uses to identify the item (it can be an appointment, task, email
etc.). I have found with email using exchange that the EntryID can be a lot
larger. Anyhow do some browsing on that property