View Single Post
  #2  
Old June 22nd 06, 06:50 AM posted to microsoft.public.outlook.program_vba
Michael Bauer
external usenet poster
 
Posts: 435
Default Browse and select mail messages?

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?

Ads