VBA basics - Logging into Outlook

[Brian Bristol]

Hello,

I am trying to use the automation object model to Launch Outlook,logo
as a specific user and display the inbox. This is what I have so fa
but there is a "connect" dialog that connects to the exchange serve
that requires a password. I can not seem to get past it.. Any idea
out there?

Private Sub Command1_Click()
Set myOlApp = CreateObject("Outlook.Application")
Set myNameSpace = myOlApp.GetNameSpace("MAPI")
myNameSpace.Logon "profile", "password" , True, True
Set myFolder = myNameSpace.GetDefaultFolder(6)
myFolder.Display
myNameSpace.Logoff
End Su

 

[Eric Legault [MVP - Outlook]]

You need to use CDO, not the Outlook Object Model, to login to Outlook with a
specific profile:

How to use CDO 1.21 to log on to a MAPI session by using the default profile
of the current user:
http://support.microsoft.com/default.aspx?scid=kb;en-us;171422