A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - General Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How Can I Browse To Outlook Folder From Access VBA



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old February 1st 09, 03:50 PM posted to microsoft.public.access.externaldata,microsoft.public.access.modulesdaovba,microsoft.public.access.modulesdaovba.ado,microsoft.public.outlook
Alan B.
external usenet poster
 
Posts: 3
Default How Can I Browse To Outlook Folder From Access VBA

I'm using Access 2000. When I create a link to an Outlook folder using the
"Get External Data - Link Tables" menu option, I am able to Browse to and
select the folder that I want to link to.

Is there any VBA code available that will let my user click a Browse button,
and then browse to an Outlook folder - so that the user can add the path to
that folder to a field in my db? I do this all the time with folders
(directories) that are on the harddrive.

Thanks in advance.

Alan B.


  #2  
Old February 1st 09, 09:24 PM posted to microsoft.public.access.externaldata,microsoft.public.access.modulesdaovba,microsoft.public.access.modulesdaovba.ado,microsoft.public.outlook
neo [mvp outlook]
external usenet poster
 
Posts: 718
Default How Can I Browse To Outlook Folder From Access VBA

Sounds like you are after the Namespace.Pickfolder method. (Note: This is
exposed by Outlook's OOM.)

"Alan B." wrote in message
...
I'm using Access 2000. When I create a link to an Outlook folder using the
"Get External Data - Link Tables" menu option, I am able to Browse to and
select the folder that I want to link to.

Is there any VBA code available that will let my user click a Browse
button, and then browse to an Outlook folder - so that the user can add
the path to that folder to a field in my db? I do this all the time with
folders (directories) that are on the harddrive.

Thanks in advance.

Alan B.



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot display the folder. Microsoft Office Outlook cannot access thespecified folder location. Boppy Outlook - General Queries 1 December 19th 07 12:16 AM
VPN and browse for attachment problem T McShu Outlook - Installation 1 September 19th 07 02:50 PM
Internet Explorer won't browse Bill DeShawn Outlook Express 2 June 12th 07 03:30 PM
Browse Won't Open in Find Message Candy Outlook Express 6 December 21st 06 12:50 AM
Cannot browse zip files when attaching to email Gordon Outlook - Installation 1 February 24th 06 09:14 PM


All times are GMT +1. The time now is 11:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.