Linking/Importing Outlook Emails to Access

[Trevor Aiston]

We record project data in a Access 2003 database. But most of the
correspondence relating to any specific project is through Outllook.

I there an easy wait to link/import outlook email to an access database? Or
is it a question of copy and paste.

Thanks

Trevor

 

[Piet Linden]

We record project data in a Access 2003 database. But most of the
correspondence relating to any specific project is through Outllook.

I there an easy wait to link/import outlook email to an access database?  Or
is it a question of copy and paste.

Thanks

Trevor

File, Get External Data, Link Tables
Then choose Outlook as the File Type
Choose Personal Folder and then navigate down to your Inbox, and
select it.

Now it's a linked table and you can query it as if it were a local
table.

 

[Trevor Aiston]

Hi Thanks for that.

But it looks like the link will only work with 1 folder, not subfolders?

Is that correct?

Trevor

 

[John W. Vinson]

Hi Thanks for that.

But it looks like the link will only work with 1 folder, not subfolders?

Is that correct?

Yes, as written. Wouldn't a command button that can destroy all files and all
subdirectories be sort of a small nuclear tactical device, best implemented
only with stringent supervision and controls?

If you want the user to be able to destroy an entire hard disk (which it will
if they pass C:\ for example), you can; you'll need to have code to identifiy
the directories within the directory and recursively call itself to destroy
them too.