kosenrufu
asked on
How to modify this code so the profile is automatically selected?
Public Sub OutlookStart()
On Error Resume Next
Dim objOL As Object
'check if Outlook is running
Set objOL = GetObject(, "Outlook.Application")
'on error start Outlook
If Err.Number <> 0 Then '
Err.Clear
Shell "C:\Program Files\Microsoft Office\Office12\outlook.ex e", vbMinimizedFocus
DoEvents
End If
Set objOL = Nothing
End Sub
Currently I configured Outlook to prompt for profile. I want to automatically select the profile and bypass the prompt window. How can this be done with VBA?
Thanks
On Error Resume Next
Dim objOL As Object
'check if Outlook is running
Set objOL = GetObject(, "Outlook.Application")
'on error start Outlook
If Err.Number <> 0 Then '
Err.Clear
Shell "C:\Program Files\Microsoft Office\Office12\outlook.ex
DoEvents
End If
Set objOL = Nothing
End Sub
Currently I configured Outlook to prompt for profile. I want to automatically select the profile and bypass the prompt window. How can this be done with VBA?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.