Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disregard the Outlook dialog box sending task/eMail from Excel 2003
hi all,
currently i am creating a macro in Excel 2003 which will create an Outlook Task which is assigned and send to the recipient. the issue is that Outlook 2003 displays a dialog box asking if this access is allowed. my question is it at all possible to have this dialog box either suppressed or have it automatically acknowledged by line of code. the code so far: Sub CreateTask() Dim olApp As Outlook.Application Dim olTsk As TaskItem Dim objRecipient As Outlook.Recipient Set olApp = New Outlook.Application Set olTsk = olApp.CreateItem(olTaskItem) With olTsk .Assign Set objRecipient = ") .Subject = "Test Task1" '.Status = olTaskInProgress .Importance = olImportanceHigh .DueDate = DateValue("06/26/03") .TotalWork = 40 .ActualWork = 20 .Save .Send End With Set olTsk = Nothing Set olApp = Nothing End Sub any help is mostly appreciated - cheers.... .....jurgenC! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending Email from within Excel 2003 using Outlook 2003 | Excel Discussion (Misc queries) | |||
Outlook Email Send Dialog Boxes, Excel 2003 How to Turn Off or Rem | Excel Discussion (Misc queries) | |||
How to link to an Excel file when sending an email in Outlook? | Excel Discussion (Misc queries) | |||
Sheet vs File size when sending email in Outlook | Excel Discussion (Misc queries) | |||
Prevent dialog - Prevents Sending Excel File From Outlook | Excel Programming |