Copy all emails in outlook folder and paste them in similar system folder and ms access

Hi all,

I need on daily basis to move all emails into a folder in the hard drive. the folder has the same setup as the one in outlook. After that, I need to
After searching the web, I found two macros that only do part of it.
It would be great if the code could be combined or fired one after the other one to save all the emails from the folder (could be any one selected) to the hard drive and adding a link to access database so I can easily open the emails from the folder.
The fact that I need this is because we have a huge amount of emails and there are 10 of us to access them. a .pst file is no solution at all as one at a time can read the emails.

I don't ask that the code is written form me, just if you are able to help me step by step to learn as well.

The code I have so far:

Please Login or Register  to view this content.

The above code only takes the ones selected, but it needs to be changed that it will be a selected folder.

Please Login or Register  to view this content.

The above code only takes the personal inbox, it needs to be set so the selected folder is the one he will get the emails from.

Greetings.

Hi all,

I found a possible solution, but I have error on the part:

Please Login or Register  to view this content.

Can any one point me where it goes wrong?

Please Login or Register  to view this content.

Hi all,

Please Login or Register  to view this content.

compile error:
User-defined type not defined

Forgot to mention the above error :-)

Found that one too,
Just forgot to add the ADO reference in tools :-)

The next error I get is:

Please Login or Register  to view this content.

It is not in the collection, so no clue what that means.

Hi all,

I got it working, but have problems with the selection of the folder.
For now I can only use an imbox from outlook and it will copy all the subfolders and emails, but I only need to select a subfolder with subfolders in it where the emails are that I need to backup.
Is it possible to force that?

Greetings.