Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-27-2011, 04:30 AM   #1
gasbored
Newly Registered User
 
Join Date: Jul 2007
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
gasbored is on a distinguished road
Import from Outlook Folder

When using Office 2003 I was able to import emails from an Outlook folder via the 'Get External Data' menu. This let me import into the same table each time.

However on Office2007 I have been trying to import them by the following steps:
External Data > More > Microsoft Outlook Folder
I select the table to import them into, and select the #Append a copy of the records to the table' option

This gives me the following message:

"Method 'Value'of object '_AccessProperty' failed"

Any ideas?

gasbored is offline   Reply With Quote
Old 07-27-2011, 05:14 AM   #2
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,142
Thanks: 81
Thanked 2,010 Times in 1,958 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Import from Outlook Folder

I don't have Acc2007 but found this link that may be useful.
http://www.msofficetuneup.com/2008/0...n-access-2007/

Good luck.
jdraw is offline   Reply With Quote
Old 09-21-2011, 06:14 AM   #3
LadyDi
Newly Registered User
 
Join Date: Mar 2007
Location: North Canton, Ohio
Posts: 894
Thanks: 52
Thanked 1 Time in 1 Post
LadyDi is on a distinguished road
Red face Re: Import from Outlook Folder

Is there a way to run this import with vb code instead of having to go through the steps of getting "external data" each time? I tried saving the import steps and then using vb code to run the saved import. The only problem with that, is that no one else can run the import I saved.

LadyDi is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a folder in outlook D.Mair Modules & VBA 1 04-29-2010 10:09 AM
Linking Table to Outlook Folder shamas21 Tables 2 01-13-2010 06:43 PM
Linking outlook folder shamas21 General 0 12-23-2009 09:33 AM
Emails From Query to outlook folder TallMan Queries 2 03-09-2009 09:49 AM
Get Outlook Folder Name cowannbell Modules & VBA 2 12-09-2005 12:48 AM




All times are GMT -8. The time now is 09:17 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World