VBA Outlook and Access 2007

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?
--
Thanks. JSheldon

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

"JSheldon" <JSheldon.RemoveThis@discussions.microsoft.com> wrote in message
news:52FAF080-DDCE-4ACC-B85E-49471C6E4B3E@microsoft.com...
>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?
> --
> Thanks. JSheldon