Linking/Importing Outlook Emails to Access

  • Thread starter Thread starter Trevor Aiston
  • Start date Start date
T

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
 
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
Click to expand...

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.
 
Hi Thanks for that.

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

Is that correct?

Trevor
 
Hi Thanks for that.

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

Is that correct?
Click to expand...

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.
 
Back
Top