[AccessD] Export Contacts to Outlook

Jack and Pat drawbridgej at sympatico.ca
Sat Nov 6 18:53:50 CDT 2010


Rocky,
I have had similar problem with syntax for opening (identifying) a folder in
Outlook 2003. Pickfolder works but I couldn't get to a folder using vba
without pickfolder. Anyway, I saw your request and did some searching and
trials.

I got a response from OutlookCode.com which I have adjusted and can now open
my Folders using vba.

My original request and a jpg of my Outlook folder structure and the
solution (last message in the link below) are useful to you.  My id was
(OrangeCat)

http://www.outlookcode.com/threads.aspx?forumid=2&messageid=32433

Hope you can adapt it as needed for your situation.
jack

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Saturday, November 06, 2010 11:36 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Export Contacts to Outlook

Andy:

I still get  "Operation failed.  An object could not be found".  But when I
use Set olFolder = olNameSpace.PickFolder and select DocketWorks (sub folder
under Contacts) it works and olFolder.Name shows "DocketWorks".

What do you suppose I'm doing wrong?

TIA

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Saturday, November 06, 2010 12:33 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Export Contacts to Outlook

Hi Rocky

This works in my Outlook Contact updating mdb

Set objOutlookFolder = objOutlookNameSpace.Folders("Public
Folders").Folders("All Public Folders").Folders(strFolder)

Andy


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: 05 November 2010 21:41
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Export Contacts to Outlook


Me too -- Rocky, don't forget about Helen's site -- there might be an
example of this there.

Susan H.


> Nope, sorry.  I usually just work it out in logical bits when I run 
> into that sort of thing.
>
> Charlotte
>
>
>>Charlotte, do you know the right syntax for specifying a subfolder?
>>
>>Susan H.
>>
>>
>>So try creating a folder call Contacts and see if that works.  If it 
>>does create a folder object for DocketWorks based on the Contacts 
>>folder.
>>

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list