Outlook Emails in Access

[PitchBlackSheep]

I have an office of Real Estate agents who use our (single) Access 2000
database to keep track of clients. Our agents email our clients
everyday using Outlook 2000.

I'm trying to find a way to have those emails associated with the
client's record. Any ideas? All I need is a nudge in the right
direction ;)

Thank you in advance!!!

[deko]

> I have an office of Real Estate agents who use our (single) Access 2000

database to keep track of clients. Our agents email our clients
everyday using Outlook 2000.

I'm trying to find a way to have those emails associated with the
client's record. Any ideas? All I need is a nudge in the right
direction ;)

Clearly, the client's email address is the unique identifier that can be
used to associate messages with clients. So you'll need each client's email
address stored in the database and related to the customer ID. Then you can
have code that searches the PST (or any Outlook folder) for messages that
have an email address belonging to the selected client and populate a table
with whatever you want - date received, sent, body, etc. You'll need a memo
field if you want to grab the message body. I have a temp table that does
this since it makes no sense to store message info that's already stored in
Outlook. Use an "Email Search" form or something. This works well with
local PSTs, not sure otherwise. You'll need a reference to Outlook. But you
can do lots of stuff with Outlook automation. The limitation I found
frustrating is that Outlook offers no method to take you to a particular
date or message in the Inbox. So I can search my PST and view the results,
but I can't click on something and automatically go to that date or message
in the Inbox.

[PitchBlackSheep]

Thank you so very much!

We do have the email addresses in the database. We use Exchange as our
mail server and each agent has their own profile. I'm wondering if I
can have the code reference Exchange? Probably not since the mail is
not stored there. I'll have to do some digging and testing . . . I'll
break something before this is over but that's half the fun anyway :)

Thanks again!!!

[pietlinden]

but once you've attached to the Inbox, you can query the table pretty
much any way you want. (Well, except for the annoying fact that you
can't see all the fields in the Outlook inbox table). Does the user
need *all* the correspondence from the client as a permanent archive?
Then you could copy the data to the Access table. (Link to the inbox,
then use a make-table query to create a local copy). then if you
really wanted, you could grab Danny Lesandrini's "inbox watcher" code
from his website (amazecreations.com?) and have the watcher execute
code anytime you have new mail (like import the new stuff... just a
find unmatched query that you turn into an append query.) then you can
have all the work happening without intervention.

[deko]

> but once you've attached to the Inbox, you can query the table pretty

much any way you want. (Well, except for the annoying fact that you
can't see all the fields in the Outlook inbox table).

Another thing I found annoying is that the From and Sender Name fields
contain the "display name" rather than the actual email address. This makes
it difficult (sometimes impossible) to associate messages with contacts.
AFAIK, there is no way around this, other than using Automation code to
inspect each message and copy matching records to a table, which is what I
suggested.