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 6109
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 programmaticall y, 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
programmaticall y, 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.c om...
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 programmaticall y, 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 programmatical ly, 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 programmaticall y, 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.c om...
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 programmatica lly, 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 programmaticall y, 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 maximum of 5 deep starting at the INBOX.
So.... the problem is that Outlook is running too slow now
and I have to figure out how I can organize these messages
|
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 have those emails associated with the
client's record. Any ideas? All I need is a nudge in the right
direction ;)
Thank you in advance!!!
|
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 email. Any
ideas?
Thanks in advance.
|
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 stored states
that it is an expression and will not accept entry, nor will it
automatically conjoin the first and last names as it would normally do
if you entered it in an outlook form. Without this when you click on
the entry in outlook instead...
| |
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 using which sends
If you want to see the above code in its full context you can see it here:
http://www.thescripts.com/forum/thread581521.html
Willakawill helped me out a bit with getting access to remember if it had already added the...
|
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 with the results from an online survey and I need to get the data into Access for reporting proposes.
-------------------------------------
I can get it in Access with a copy/ paste to Excel the use “Text to Columns” Then “Pate Special”/...
|
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 doesn't support this property or method', for some emails is ok, but otherones, it just cant find the data of certain fields such as Received Time, From etc
Please if someone could help me with some advice.. Thankss
Private Sub Command0_Click()
...
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |