| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trigger outlook macro from excell.
I have a macro that will only run in outlook, is it possible to open outlook
and trigger that macro ("sendtasks") from excell? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trigger outlook macro from excell.
Dim ol As Object
Set ol = CreateObject("outlook.application") Call ol.sendtasks HTH, Bernie MS Excel MVP "Atishoo" wrote in message ... I have a macro that will only run in outlook, is it possible to open outlook and trigger that macro ("sendtasks") from excell? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trigger outlook macro from excell.
Thanks Bernie
i get object does not support this property or method on that one! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
trigger outlook macro from excell.
The macro
Sub sendtasks() 'code 'End Sub must be in either Outlook's default project or in the ThisOutlookSession's codemodule. HTH, Bernie MS Excel MVP "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Dim ol As Object Set ol = CreateObject("outlook.application") Call ol.sendtasks HTH, Bernie MS Excel MVP "Atishoo" wrote in message ... I have a macro that will only run in outlook, is it possible to open outlook and trigger that macro ("sendtasks") from excell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel trigger Outlook reminder? | Excel Worksheet Functions | |||
| how do i call an Outlook Procedures in Excell Macro | Excel Programming | |||
| copy from excell to outlook | Excel Worksheet Functions | |||
| Excell & Outlook Express | Excel Programming | |||
| Can reciept of an email in outlook express be used to trigger an even in excell | Excel Programming | |||
Linear Mode
