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: 3,429
gmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to all
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: 3,429
gmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to all
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 - Senior Forums

All times are GMT -7. The time now is 03:35 AM.


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