If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking/Importing Outlook Emails to Access
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 |
#2
|
|||
|
|||
Linking/Importing Outlook Emails to Access
On Feb 26, 7:29*am, Trevor Aiston
wrote: 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. |
#3
|
|||
|
|||
Linking/Importing Outlook Emails to Access
Hi Thanks for that.
But it looks like the link will only work with 1 folder, not subfolders? Is that correct? Trevor "Piet Linden" wrote: On Feb 26, 7:29 am, Trevor Aiston wrote: 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. |
#4
|
|||
|
|||
Linking/Importing Outlook Emails to Access
On Fri, 27 Feb 2009 03:45:01 -0800, Trevor Aiston
wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|