I'm working on an Excel macro which gathers information from various files
(Word, Excel, PowerPoint), as well as email messages. The locations for the
files are passed with variables. I was thinking about adding some error
handling to allow the user to search for and select the file(s) themselves if
the macro can't find the file(s) based on the path and file name passed to it.
I was going to use the Application.GetOpenFilename() method so I would not
have to incorporate any additional library references.
What I would like to know is if there is a similiar method I could use to
allow a user to browse through Outlook folders and select a particular mail
message if the macro can't find the message it needs based on the variables
(outlook folder, subject, attachments,...) passed to it?

--
Message posted via http://www.officekb.com

Am Wed, 21 Jun 2006 15:33:28 GMT schrieb Fox via OfficeKB.com:

To browse the folders you can call the Pickfolder method. Then you´d need to
show all the its messages in a proper control like a grid.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --


I'm working on an Excel macro which gathers information from various files
(Word, Excel, PowerPoint), as well as email messages. The locations for
the
files are passed with variables. I was thinking about adding some error
handling to allow the user to search for and select the file(s) themselves
if
the macro can't find the file(s) based on the path and file name passed to
it.
I was going to use the Application.GetOpenFilename() method so I would not
have to incorporate any additional library references.
What I would like to know is if there is a similiar method I could use to
allow a user to browse through Outlook folders and select a particular
mail
message if the macro can't find the message it needs based on the
variables
(outlook folder, subject, attachments,...) passed to it?