VBA Outlook and Access 2007

  • Thread starter Thread starter JSheldon
  • Start date Start date
J

JSheldon

I have an Outlook folder with several thousand messages. I want to look
through the body of them, extract some information, and save it to an Access
data table. I thought I could do this from Access, but every time I try to
look at the attached folder in Access, Access closes and has to restart. I've
tried to import and look at folders with 20 or fewer messages and there is no
problem, but it just appears to be the large folder size. Does anyone have
any pointers on how to use VBA to open up a designated Outlook folder and
capture the sender, subject and message body?
 
From Access, File, Get External Data, Link Tables, choose Exchange or
Outlook, etc..... Then you can query the table or whatever you want to do
with the data. Have you tried that?

Joel
 
Back
Top