import mail in Access From outlook (exchange environment)
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.
VB Code:
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
Re: import mail in Access From outlook (exchange environment)
A couple of things...
If you store the attachments into an Access db it will bloat the db size dramatically and if the db gets corrupted you loose all your data.
What do you mean - Access/SQL? You have the choice of using either Access or SQL Server?
Lastly, is the shared mailbox added to the users outlook profile/session as a secondary pst file or still as an Exchange mailbox?
Re: import mail in Access From outlook (exchange environment)
Robdog,
Thanks for the reply. I should have been a little more specific in my post.
At this moment we're doing a for us big project for a helpdesk. Several departments are to use this helpdesktool with 2 up to 8 operators/users at the same time. Because this is a temporary application, the focus lies more on fast delivery than on reliability.
We have chosen to build an Access application which will be upscaled to SQL.. A front/back end structure with a object orientated layer between them. In this way it's not necessary to have the SQL tables in the Access forms database.
One of the functionalities is to import mail from Outlook into the applicatoin and link them to the tickets. All departments have their own functional mailbox which is added in outlook. So the user has it's own email box in outlook and the functional mailbox of it's department.
Second they want to keep the attachments 'in' the application linked to the ticked. This can be done by placing files in a table or have these files external somewhere on a server. BEcause of privacy and security it's not allowed to have loose files on the server. This leaves us to store them internally. I may be propose the external file storing again....
The problems we come across are the following
1 make a pointer to the functional mailbox./
VB Code:
Set myInbox = myNameSpace.GetDefaultFolder(olFolderInbox)
This code points to the personal mailbox of the user
2 stroring the attachments internally. We prefer without a temporary save on the server
3 Sending mail on the functional maibox account instead of the personal account.
I hope that I have explained it a little. Thanks again for your reply and for a answer.
Sincerely
Jurjen