Run Outlook Macro from Autoit Script

[sumandevadiga]

Hello 

I would like to Run Outlook macros from Autoit every 1 hour, below script unable to run macros.

While 1
 
    $Minute = Random(1,59,1)
        Do 
    
            Sleep(1000)    
 
        Until @Min = $Minute   
     
    ; do whatever    
    ; Since we want it to run randomly once an hour, we need to calculate how much time is left before the hour is up, and sleep that length of time.
        $s = ((60 - $Minute) * 60) * 1000     
            Sleep($s)
        $oOApp = ObjCreate("Outlook.Application")
    $oOApp.Run("SaveAttachments") ; Run Outlook Macros

WEnd

 

 

[JLogan3o13]

@sumandevadiga as is usual, you're not providing enough information. What does the macro do exactly? There is a well-defined library for Outlook in AutoIt; there may be a better way to accomplish what you're after, but it is impossible to tell with little to no description.

[sumandevadiga]

Hello Logan

Sorry for incomplete information, actually i was looking only for the autoscript which can execute the outlook macros, likewise i i used below script to run excel macros.

Basically i have a Macro in Outlook which i would like to run every hour to check specific subject email and fetch the details and save in excel, so macro is ready only i required a autoit script which will active this macro every hour.

let me know if more information required.

#include <Excel.au3>
#include <MsgBoxConstants.au3>
$oExcel = _ExcelBookOpen ("C:\Test1\Test.xlsm")
$oExcel.Run("SaveWorksheetsAsCsv")
_ExcelBookClose($oExcel)
 

 

[Juvigy]

Why don't you convert the Outlook macro to autoit and run it like that?

Because calling outlook macros from external application is not possible.

 

Edited April 13, 2018 by Juvigy
update

[water]

The Outlook application object does not provide a Run method.

Object Model for Outlook 365: https://msdn.microsoft.com/en-us/vba/outlook-vba/articles/application-object-outlook

[Skysnake]

Perhaps you need to think about this differently.

I see a functional split.

(a) the scheduler

(b) the Outlook macro

First, make the scheduler to run the way you want.  Random etc.  There are tools out there, or use the Windows Task Scheduler.

This scheduler then triggers the Outlook script.  This can be compiled as an EXE, so when ever the scheduler launches it, it runs like a little app, doing what you want.  Or, if you want to include the scheduling, a service may work better.

Perhaps the point is that you can achieve your stated goal, but you will need to do the work.  There is no out of the box solution for what you want.