Hi,
I'm trying to build a database/work tool.
Currently, one of the departments get all their work via e-mails and currently they are just using outlook + folders etc.
What I would like is an outlook macro which exports all the emails which get received in the "inbox" folder to an access database.
I would then like the macro to take all those emails that it has exported and move them to another folder called "exported".
The information i would like exported to an access database is:
To:
CC:
From:
Received Date:
Body Text:
i guess also attachments but im not 100% sure if its necessary.
Moving forward i would like to build forms n stuff in access so it looks more like a work tool etc but i guess this is the starting point.
Also to keep in mind, this "inbox" folder is a shared mailbox, not the "inbox" of my personal email.
I have to admit, i did find this http://blogs.techrepublic.com.com/howdoi/?p=119 but it doesnt show the recieved date and also the code for some reason doesnt work for me.
Also, just so you know, i am using Outlook 2003 as my e-mail client
hope someone can help me with this, cheers
Bookmarks