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
5  6066 
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
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
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
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Bob |
last post by:
Hi Everybody
A tough one!!!
Is there any way that incoming eMails (MailItems) into Ms Outlook can be used to automatically
create records in a ms Access table or sub table.
Smiley Bob
|
by: Curious George the Monkey |
last post by:
Hi,
I have about 20,000 emails of which about 1% of them have
attached word, excel, jpeg, pdf, powerpoint files.
The emails are located in about 1000 folders. The hierachy
of folders is...
|
by: PitchBlackSheep |
last post by:
I have an office of Real Estate agents who use our (single) Access 2000
database to keep track of clients. Our agents email our clients
everyday using Outlook 2000.
I'm trying to find a way to...
|
by: Strasser |
last post by:
In Access2000 mass emailing worked perfectly (very powerful tool!).
Doesn't work when using XP version of both Access and Outlook, even
though I checked the box to ensure that I was sending the...
|
by: sfriedman |
last post by:
I was able to successfully link my Outlook Contacts table to an Access
Database and create an entry form. Unfortunately the Displayname field
which is one of the key fields for how the contact is...
|
by: Kosmos |
last post by:
Good afternoon everyone, just wondering if anyone knew if it's possible to send meetings or appointments through email when you run VBA or SQL code in Access 2003? The following is the code I've been...
|
by: Boxcar74 |
last post by:
I think this is a little crazy but I supposed to figure out how to get the body of an email message (Outlook) into an Access DB table, with little to no effort :)
Here is the deal I receive email...
|
by: obroie |
last post by:
Hi all,
I am trying to move emails from Outlook into an Access table, the code below worked for me before, but now I am having a problem as this error message comes up: Run-time error 438 'Object...
|
by: Alfred |
last post by:
Hi
Is it possible to import the emails in the cc field from outlook directly to
an access table.
Help will be appreciated
Thanks
Alfred
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |
