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 |
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 |