Linked tables to Exchange

[eilob]

Hi,
I have a linked table in Access which is linked to an Inbox Folder in Microsoft Outlook. The table will reflect the emails that come in into the Inbox. I need that every time an email comes in be transferred from the Linked table to a normal table. This is to keep a record of every email that comes into the Inbox. How could I set this up automatically so that I can keep a record of every single email that comes in. If in the Inbox a mail is deleted or transferred to another folder this email will dissapear from my linked table so it reflect everything that happens on the Inbox folder. That's the reason why a need to copy the email, just to keep a record of all the emails that come in.

THANKSS!!! : )

[nico5038]

Hmm, nice problem, but no 100% solution will be possible when you can't control the access to the inbox.
You should be sure that no one can move/delete emails between running the needed INSERT INTO query to your local table.

Personally I've solved this once by moving the processed emails into a different folder. Thus (and by no longer using the inbox) made the prcessing easy as only not yet processed emails would be present in the inbox.

Idea ?

Nic;o)

[Boxcar74]

I had a similar issue I just ran a Make Table Query off of the Link Inbox Folder. That worked great.

I not sure but after the table is created you probably want to run an Update Query once and a while to keep the table, current.

Hope that Helped at all.