Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All,
I use the following function in Excel to call outlook before creating an email. Using Office 2010 I'm finding that even with the correct setting in the Mail section of our Control Panel that if OL is not running when the function runs then a window appears asking to Choose Profile. I've tried commenting out the two marked lines below and it all seems to run without asking for the profile - would it be logical to assume that these two lines are connected with the application asking for a profile ? Any help much appreciated Jason. Private Function OpenOutlook() On Error Resume Next Set myOutApp = GetObject(, "Outlook.Application") If Err.Number = 429 Then Set myOutApp = CreateObject("Outlook.Application") 'possible offending code ' Set myNS = myOutApp.GetNamespace("MAPI") ' myNS.Logon ' End If On Error GoTo 0 End Function 'OpenOutlook |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pasting from Excel to Outlook with VBA code | Excel Programming | |||
excel code tweak for outlook - confusing | Excel Programming | |||
How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
How to get rid of the warning msg from Outlook when sending email via VBA code in Excel | Excel Programming |