Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2021, 06:39 AM
Elli_D Elli_D is offline start a program with the appointment Windows 10 start a program with the appointment Office 2019
Novice
start a program with the appointment
 
Join Date: May 2021
Posts: 3
Elli_D is on a distinguished road
Default start a program with the appointment


Hi, I would like to start a program, if an appointment occours (OL 2019). Unfortunately I can only play a sound on this point. Is this possible to start a cmd or vbs or whatever with a calender entry? Extra programms (add ins, extensions...) would be ok.


Greetings, Elli_D
Reply With Quote
  #2  
Old 05-02-2021, 11:13 PM
gmayor's Avatar
gmayor gmayor is offline start a program with the appointment Windows 10 start a program with the appointment Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 05-03-2021, 06:19 AM
Elli_D Elli_D is offline start a program with the appointment Windows 10 start a program with the appointment Office 2019
Novice
start a program with the appointment
 
Join Date: May 2021
Posts: 3
Elli_D is on a distinguished road
Default

Hey gmayor, this sounds good. But, what is a "ThisOutlookSession module" and where I have to place the macro? All i see i have the option to choose a sound. Not a vbs.
Or do you mean the windows scheduler? This is my current way...
Reply With Quote
  #4  
Old 05-03-2021, 09:09 PM
gmayor's Avatar
gmayor gmayor is offline start a program with the appointment Windows 10 start a program with the appointment Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Open the VBA editor (ALT+F11)
Locate the ThisOutlookSession module





And paste the code in that module.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 05-04-2021, 12:07 AM
Elli_D Elli_D is offline start a program with the appointment Windows 10 start a program with the appointment Office 2019
Novice
start a program with the appointment
 
Join Date: May 2021
Posts: 3
Elli_D is on a distinguished road
Default

It works! Great! Thank you very much! Greetings from Germany :-)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
start a program with the appointment Message "isn't your default program", while in fact it is my default program jmpavo Office 1 11-23-2017 01:09 PM
start a program with the appointment New to word: formatting a program with bios and pix; needs to be easily editable. Where to start?! bgbg4us Word 1 04-02-2015 11:06 PM
add Appointment Vibov Excel 0 03-23-2015 04:30 AM
difference between scheduled start and start ketanco Project 3 01-15-2015 07:53 AM
Appointment View aligatrjoe Outlook 0 01-18-2011 03:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft