Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba - Opening Outlook with Vba
Hi all,
I am keep trying to generate an MS Outlook Task from Excel Vba. I thought I can first open Outlook, and then trying to generate task o note. First of all, could anybody help me with the first step, opening M Outlook? Iam trying this code unsuccessfuly: (I use Outlook 03 with Xp prof) Private Sub OpeningOutlook() Dim OutLk As Application Dim B As String B = "C:\Program Files\Microsoft Office\OFFICE11\OUTLOOK.EXE" Set Out = GetObject(B) OutLk.Application.Open OutLk.Application.Visible = True 'Here generating task or note OutLk.Parent.Windows(1).Visible = True OutLk.Application.Quit End Sub Thank you all! Aldo -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba - Opening Outlook with Vba
Dim olApp as Object On Error Resume Next Set olApp = GetObject(,"Outlook.Application") If olApp Is Nothing Then Set olApp = CreateObject("Outlook.Application") End If -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "ajliaks " wrote in message ... Hi all, I am keep trying to generate an MS Outlook Task from Excel Vba. I thought I can first open Outlook, and then trying to generate task or note. First of all, could anybody help me with the first step, opening MS Outlook? Iam trying this code unsuccessfuly: (I use Outlook 03 with Xp prof) Private Sub OpeningOutlook() Dim OutLk As Application Dim B As String B = "C:\Program Files\Microsoft Office\OFFICE11\OUTLOOK.EXE" Set Out = GetObject(B) OutLk.Application.Open OutLk.Application.Visible = True 'Here generating task or note OutLk.Parent.Windows(1).Visible = True OutLk.Application.Quit End Sub Thank you all! Aldo. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop opening outlook in excel | Excel Discussion (Misc queries) | |||
Opening outlook in Excel | Excel Discussion (Misc queries) | |||
Error opening Outlook 2002 | Excel Discussion (Misc queries) | |||
Opening Excel Files from Outlook | Excel Discussion (Misc queries) | |||
Error in code opening Outlook | Excel Programming |