By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,402 Members | 1,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,402 IT Pros & Developers. It's quick & easy.

Script to Automate 'Get External Data' in Access

P: 1
I can manually 'suck' data out of Outlook emails into an Access Table. I need a way to include that part of the process using an Access Macro if possible.
So that I run the Macro and the data is pulled into the table without the laborious open File, then Get External Data, then Import and then setting 'Files of Type' to Outlook and then hunting to the appropriate email folder.
Is there a way? Hay-elp!
I am using MS Access 2000 and Outlook 2000 with Windows 2000.
Oct 11 '07 #1
Share this Question
Share on Google+
1 Reply


Jim Doherty
Expert 100+
P: 897
I can manually 'suck' data out of Outlook emails into an Access Table. I need a way to include that part of the process using an Access Macro if possible.
So that I run the Macro and the data is pulled into the table without the laborious open File, then Get External Data, then Import and then setting 'Files of Type' to Outlook and then hunting to the appropriate email folder.
Is there a way? Hay-elp!
I am using MS Access 2000 and Outlook 2000 with Windows 2000.
Have you considered having the inbox as a 'linked table' (note: not imported) always there and available in access to run any queries directly on that linked table?

File....Get External Data ...Link Tables...Exchange (or Outlook)....personal folders....inbox (or whichever other folder you might wish)

Regards

Jim
Oct 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.