You can use the reminder event to run a macro to start your program e.g. put the following in the ThisOutlookSession module and it will fire when there is an appointment reminder.
Code:
Private Sub Application_Reminder(ByVal Item As Object)
If TypeName(Item) = "AppointmentItem" Then
' Call your macro here
MsgBox "It works!"
End If
End Sub