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

Importing Outlook emails into an Access table

P: n/a
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
Oct 16 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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
Oct 16 '07 #2

P: n/a
On Mon, 15 Oct 2007 22:29:25 -0400, "NEWSGROUPS" <he******@yahoo.com>
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
Oct 16 '07 #3

P: n/a
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" <no*************@cox.netwrote in message
news:it********************************@4ax.com...
On Mon, 15 Oct 2007 22:29:25 -0400, "NEWSGROUPS" <he******@yahoo.com>
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

Oct 16 '07 #4

P: n/a
On Mon, 15 Oct 2007 23:31:39 -0400, "NEWSGROUPS" <he******@yahoo.com>
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" <no*************@cox.netwrote in message
news:it********************************@4ax.com.. .
>On Mon, 15 Oct 2007 22:29:25 -0400, "NEWSGROUPS" <he******@yahoo.com>
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
Oct 16 '07 #5

P: n/a
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" <no*************@cox.netwrote in message
news:6i********************************@4ax.com...
On Mon, 15 Oct 2007 23:31:39 -0400, "NEWSGROUPS" <he******@yahoo.com>
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" <no*************@cox.netwrote in message
news:it********************************@4ax.com. ..
>>On Mon, 15 Oct 2007 22:29:25 -0400, "NEWSGROUPS" <he******@yahoo.com>
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

Oct 16 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.