Microsoft Access - Automate Importing from Exchange

[Phantek]

I have a database to which I wish to import information from emails in my outlook. I keep the emails in a specific directory to make it easy. I am using Office 2003.

I can easily do this manually by going File > Get External Data > Import - then I select "Exchange()" from "Type of File", select the folder I want, and then import it all as a new table.

Is there any way I can automate this to have a command button that I can click, and it will do all these steps automatically?

Thanks in advance for your help.

 

[robcarr]

have you checked out outlookcode.com, I have used these for a lo of outlook automation, but alas I have never done what you are trying to do.

Hope this is of use, Rob.