trigger outlook macro from excell.

A

Atishoo

I have a macro that will only run in outlook, is it possible to open outlook
and trigger that macro ("sendtasks") from excell?
 
B

Bernie Deitrick

Dim ol As Object
Set ol = CreateObject("outlook.application")
Call ol.sendtasks


HTH,
Bernie
MS Excel MVP
 
B

Bernie Deitrick

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
 
Top