Outlook / VBA Automation

G

Glen Langille

I am trying to write a VBA program that will loop through all messages in a particular folder and save the attachments to my hard drive. I can do this with emails received in my personal "inbox" and related folders. However I need to retrieve messages that reside on a network drive. To access these emails manually, I do the following: 1) open Internet Explorer, 2) type, http://webmail. This opens a Microsoft Outlook Web Access Window that contains all the messages I need to access.

I can use the following code to open Internet Explorer and connect to Microsoft Outlook Web Access but I haven't found a way to work with the messages/attachments:

Set s = CreateObject("InternetExplorer.application")
s.Visible = True
' Change the following line to the Internet site you want to open.
s.Navigate "http://webmail//SampleFolder/"

I have spent too much time trying to figure this out. Can someone please help me.

Thanks.

Glen
 
Top