Link Outlook messages to MS Access

[EZ]

I need help with this:
How can I link emails from Outlook 2007 to an MS Access table? We are trying
to log messages into a table so we can query that out for reporting.
Something like:
every time there's an email a link to that message will be logged in the
table (or the entire message.. whichever is possible), once you click on that
link (may be a hyperlink) it will open up the actual message?

Any help is greatly appreciated.

Thanks.

 

[Roady [MVP]]

You can do this from within Access;
-Create a new blank table
-tab External Data
-Import-> More-> Outlook Folder

When working with Outlook and databases, this add-in might be useful to you
as well;
http://addins.howto-outlook.com/genius_connect

 

[EZ]

Thanks Roady. This will work for now. I had to use 'Link table' instead of
'Import' in order to keep a dynamic link between the two applications. I also
setup a criter in Outlook to re-direct messages from certain individuals to
my linked folder.

Thanks for the help