Code to Prompt for Selecting HDD Folders

R

Rob

Hello,

I'm desperately trying to figure out a way to have a macro in Outlook 2003
allow/prompt a user to define, via browsing, a folder on what ever available
Drive in order to save selected files, attachments and whatever. I know it's
possible in Excel and such but I can't seem to get that to work in Outlook
either. :{

Below is what I'm playing with but to no avail. :/

Code: 
Dim ns As NameSpace
Dim MyPath As MAPIFolder

Set ns = GetNamespace("MAPI")
Set MyPath = ns.Folders

MsgBox MyPath

AND

Dim ns As NameSpace
Dim MyPath As MAPIFolder
Dim fs As FileSystemObject
'Dim fsb As FileSystemBrowser

Set fs = CreateObject("Scripting.FileSystemObject")
'Set fsb = CreateObject("Scripting.FileSystemBrowser")
Set ns = GetNamespace("MAPI")
'Set MyPath = fs.GetFolder.Path
Set MyPath = ns.Folders

MsgBox MyPath


Thanks Much,
Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One more User Folder Selection Question 3
VBA - exporting serial letters to single documents 0
Copy item from Outlook to folder via Excel 12
Can not change email body content on Outlook 2010 2
Outlook 2003: Export of notes to text files 0
How to change this code to export to an existing database 0
vba timing 3
Outlook not processing all email items 1

Top