Generate Outlook Calendar meeting from FMP via applescript

[Mike Owen]

Can anyone suggest how one can generate an Outlook for Mac meeting invitation via Scriptmaker's 'Perform Applescript'.  

 

It needs to manage variables such as date, time, duration, subject, attendees, scheduling, etc

 

(I have  a pretty basic grasp of Applescript!)

[eos]

Try something along these lines:

Let ( [
  // these would be calculated from field names
  calendarName = Quote ( "Calendar" ) ;
  theDate = Get ( CurrentDate ) ;
  timeBegin = Time ( 18 ; 0 ; 0 ) ;
  timeEnd = Time ( 19 ; 0 ; 0 ) ;
  subject = Quote ( "Test" ) ;
  tsBegin = Quote ( Timestamp ( thedate ; timeBegin ) ) ;
  tsEnd = Quote ( Timestamp ( thedate ; timeEnd ) )
  ] ;
  List (
  "tell application " & Quote ( "Microsoft Outlook" ) ;
    "tell calendar " & calendarName ;
      "set newApp to make new calendar event at end of calendar events with properties 
          { 
          subject:" & subject & ",
          start time:date " & tsBegin & ",  
          end time:date " & tsEnd & "
          }" ;
    "end" ;
  "end" ;
  )
)

Look up the Outlook dictionary for the other properties, and/or create a dummy event in Outlook, then read (“get”) its complete list of properties with the ScriptEditor.

 

Using a variable to store the result of the “make” command would e.g. let you query the ID of the new event and store it in your database.