Importing Outlook emails into an Access table

[NEWSGROUPS]

I know that I can import data from my Outlook inbox by going to File -> Get
External Data -> Import -> Select Files Of Type Outlook() etc... using the
wizard but can this be done systemically via VBA code similarly to transfer
text. I actually need to import data from a group account at work. I have
searched hi and low through the Newsgroups and web and have found nothing.
Any help would be much appreciated.

Thanks to all in advance,
Markco

 

[Bob Alston]

I know that I can import data from my Outlook inbox by going to File -> Get
External Data -> Import -> Select Files Of Type Outlook() etc... using the
wizard but can this be done systemically via VBA code similarly to transfer
text. I actually need to import data from a group account at work. I have
searched hi and low through the Newsgroups and web and have found nothing.
Any help would be much appreciated.

Thanks to all in advance,
Markco

If you are using Outlook, rather than Outlook Express, send me a private
email and I will send you some code.

bob

bobalston9 At yahoo DOT com