Importing Outlook emails into an Access table

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

Re: Importing Outlook emails into an Access table

NEWSGROUPS wrote:
> 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

Re: Importing Outlook emails into an Access table

On Mon, 15 Oct 2007 22:29:25 -0400, "NEWSGROUPS"
wrote:

What's not to like about that method you so quickly dismiss?
If you want to attach programmatically, just open that "table" in
design view, inspect the table properties, and you'll know how to set
the Connect property. Then call RefreshLink.

-Tom.


>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
>

Re: Importing Outlook emails into an Access table

Tom,
It's not that I do not like this method. It is the fact that I need an
automated process for the business that I support. Besides I do not
understand what you mean when you say "If you want to attach
programmatically, just open that "table" in design view, inspect the table
properties, and you'll know how to set the Connect property. Then call
RefreshLink.

When I run the below mentioned process, I tell the wizard to import into a
new table and the fields are created. I want the group I am developing for
to be able to click a button and the emails will import.

Markco


"Tom van Stiphout" wrote in message
news:ita8h3p3vpeh13rrei539elqkdqaitvd64@4ax.com...
> On Mon, 15 Oct 2007 22:29:25 -0400, "NEWSGROUPS"
> wrote:
>
> What's not to like about that method you so quickly dismiss?
> If you want to attach programmatically, just open that "table" in
> design view, inspect the table properties, and you'll know how to set
> the Connect property. Then call RefreshLink.
>
> -Tom.
>
>
>>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
>>

Re: Importing Outlook emails into an Access table

On Mon, 15 Oct 2007 23:31:39 -0400, "NEWSGROUPS"
wrote:

Once the "table" is attached, you can write an Append query to import
the data. That query could run from your "Import: button.

-Tom.


>Tom,
>It's not that I do not like this method. It is the fact that I need an
>automated process for the business that I support. Besides I do not
>understand what you mean when you say "If you want to attach
>programmatically, just open that "table" in design view, inspect the table
>properties, and you'll know how to set the Connect property. Then call
>RefreshLink.
>
>When I run the below mentioned process, I tell the wizard to import into a
>new table and the fields are created. I want the group I am developing for
>to be able to click a button and the emails will import.
>
>Markco
>
>
>"Tom van Stiphout" wrote in message
>news:ita8h3p3vpeh13rrei539elqkdqaitvd64@4ax.com...
>> On Mon, 15 Oct 2007 22:29:25 -0400, "NEWSGROUPS"
>> wrote:
>>
>> What's not to like about that method you so quickly dismiss?
>> If you want to attach programmatically, just open that "table" in
>> design view, inspect the table properties, and you'll know how to set
>> the Connect property. Then call RefreshLink.
>>
>> -Tom.
>>
>>
>>>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
>>>
>

Re: Importing Outlook emails into an Access table

Tom,
So you are saying to link to the Outlook mailbox? Once I link will the data
always be current (I.e. always show new emails as they arrive) or do I have
to refresh the link? If I have to refresh the link, I am not sure how this
is done.

Markco



"Tom van Stiphout" wrote in message
news:6id8h3p2sdal62bf6cgc18f6c5ijs5jocv@4ax.com...
> On Mon, 15 Oct 2007 23:31:39 -0400, "NEWSGROUPS"
> wrote:
>
> Once the "table" is attached, you can write an Append query to import
> the data. That query could run from your "Import: button.
>
> -Tom.
>
>
>>Tom,
>>It's not that I do not like this method. It is the fact that I need an
>>automated process for the business that I support. Besides I do not
>>understand what you mean when you say "If you want to attach
>>programmatically, just open that "table" in design view, inspect the
>>table
>>properties, and you'll know how to set the Connect property. Then call
>>RefreshLink.
>>
>>When I run the below mentioned process, I tell the wizard to import into a
>>new table and the fields are created. I want the group I am developing for
>>to be able to click a button and the emails will import.
>>
>>Markco
>>
>>
>>"Tom van Stiphout" wrote in message
>>news:ita8h3p3vpeh13rrei539elqkdqaitvd64@4ax.com...
>>> On Mon, 15 Oct 2007 22:29:25 -0400, "NEWSGROUPS"
>>> wrote:
>>>
>>> What's not to like about that method you so quickly dismiss?
>>> If you want to attach programmatically, just open that "table" in
>>> design view, inspect the table properties, and you'll know how to set
>>> the Connect property. Then call RefreshLink.
>>>
>>> -Tom.
>>>
>>>
>>>>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
>>>>
>>