Importing attachments from multiple emails

[ir26121973]

Hi,

I am new to this forum and pretty new to Access, everything I know is self taught. My knowledge of VB is very very minimal.

I originally posted this on the 'macros' forum with no reply. I think it may fit in better in this area.

Bascially the problem I've got is that I have a shared e-mail folder where e-mails come in with attached .csv files. I receive approx. 900 e-mails a day all with these attahments.

I need to retrieve data, manipulate it etc through queries reports etc. in access. Now I'm not sure in what is thest way to do this but can someone perhaps help me with some coding that will automatically take these attachments and import them in to access.

many thanks

Chris

 

[DB7]

I think you may want to look into Outlook Automation.
create a reference to it, from the VBE window."OutlokObjectLibrary 11.0"

If you go to your object browser, you'll see the available
methods & properties in the Outlook library...