import mail in Access From outlook (exchange environment)

[Mutz]

Hi all,

I really need your help on this one. For an important project we need the following functionalities. Several users share a functional mailbox. This mailbox is added to their personal mailbox in outlook.

We need to copy the mail including the attachments in a SQL/Access table. The attachments are to be stored within the application.

What i need is code to reach the right mailbox. The code underneath will not work because of the multiple mailboxes.

Set myInbox = myNameSpace.GetDefaultFolder(olFolderInbox)

second code I need is a code to store attachments in a table, so from outlook to table. I prefer without a store procedure on disk (save as etc.)

I really hope that you could help me.

thank you very much

jurjen