Outlook in Access

[Xzibit7]

I am trying to make a database that takes certain emails from outlook for a whole group of people, with seperate email accounts and puts the subject data and who it is from in an Access table. I was wondering if getting a seperate MAPI folder for all the emails and importing that into Access was the way to go about this. Or is there a more user friendly way that anyone knows of. Thanks

 

[sxschech]

You could link or import outlook (File, Get External Data, Link, File Type Outlook) and then use a query to filter.

 

[Xzibit7]

Thanks, I think my problem is that I did not want to link everyone's seperate email account into the database(for security reasons).Also, each email has to be asssociated with a part number in the database that the user must specify which I want to try to make as user friendly as possible.