![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: add, meeting, missing, programmatically, reminder, requests |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
Hello everyone,
I often receive meeting requests without reminders. This causes a problem when I miss the ensuing meeting because no reminder pops up. Is there a way to check an incoming meeting request for a reminder, and add it if necessary? I would appreciate any sample code or pointers to websites with more information, I am an Excel programmer and new to the Outlook object model. Thx, JP |
| Ads |
|
#2
|
|||
|
|||
|
This sample does the opposite, it deletes a reminder: http://www.vboffice.net/sample.html?...ang=en&pub= 6 Set both ReminderSet properties to True and write the time to the ReminderTime properties. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Synchronize Color Categories & Ensure that Every Item Gets Categorized: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Tue, 30 Oct 2007 20:39:12 -0000 schrieb JP: Hello everyone, I often receive meeting requests without reminders. This causes a problem when I miss the ensuing meeting because no reminder pops up. Is there a way to check an incoming meeting request for a reminder, and add it if necessary? I would appreciate any sample code or pointers to websites with more information, I am an Excel programmer and new to the Outlook object model. Thx, JP |
|
#3
|
|||
|
|||
|
Thank you Michael.
I updated your code and added "Appt.ReminderMinutesBeforeStart = 15" to the Appt section, would that be sufficient, or do I need to use Meet.ReminderTime? If I need to use Meet.ReminderTime, how do I format the value I want? --JP On Oct 31, 1:40 am, "Michael Bauer [MVP - Outlook]" wrote: This sample does the opposite, it deletes a reminder:http://www.vboffice.net/sample.html?...owitem&lang=en... Set both ReminderSet properties to True and write the time to the ReminderTime properties. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Synchronize Color Categories & Ensure that Every Item Gets Categorized: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Tue, 30 Oct 2007 20:39:12 -0000 schrieb JP: Hello everyone, I often receive meeting requests without reminders. This causes a problem when I miss the ensuing meeting because no reminder pops up. Is there a way to check an incoming meeting request for a reminder, and add it if necessary? I would appreciate any sample code or pointers to websites with more information, I am an Excel programmer and new to the Outlook object model. Thx, JP |
|
#4
|
|||
|
|||
|
ReminderMinutesBeforeStart and Reminderset=true should be fine. Then save the item. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Synchronize Color Categories & Ensure that Every Item Gets Categorized: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Wed, 31 Oct 2007 14:20:57 -0000 schrieb JP: Thank you Michael. I updated your code and added "Appt.ReminderMinutesBeforeStart = 15" to the Appt section, would that be sufficient, or do I need to use Meet.ReminderTime? If I need to use Meet.ReminderTime, how do I format the value I want? --JP On Oct 31, 1:40 am, "Michael Bauer [MVP - Outlook]" wrote: This sample does the opposite, it deletes a reminder:http://www.vboffice.net/sample.html?...owitem&lang=en... Set both ReminderSet properties to True and write the time to the ReminderTime properties. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Synchronize Color Categories & Ensure that Every Item Gets Categorized: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Tue, 30 Oct 2007 20:39:12 -0000 schrieb JP: Hello everyone, I often receive meeting requests without reminders. This causes a problem when I miss the ensuing meeting because no reminder pops up. Is there a way to check an incoming meeting request for a reminder, and add it if necessary? I would appreciate any sample code or pointers to websites with more information, I am an Excel programmer and new to the Outlook object model. Thx, JP |
|
#5
|
|||
|
|||
|
Hi again,
I tried it and it doesn't seem to work. I asked someone to send a meeting request without a reminder. After I accept, I check the appointment on the calendar and there's no reminder. Could there be a delay before the reminder appears? Here's the code I used. Private WithEvents Items As Outlook.Items Private Sub Application_Startup() Dim Ns As Outlook.NameSpace Set Ns = Application.GetNamespace("MAPI") Set Items = Ns.GetDefaultFolder(olFolderInbox).Items End Sub Private Sub Items_ItemAdd(ByVal Item As Object) On Error Resume Next Dim Meet As Outlook.MeetingItem Dim Appt As Outlook.AppointmentItem If TypeOf Item Is Outlook.MeetingItem Then Set Meet = Item Meet.ReminderSet = True Meet.Save Set Appt = Meet.GetAssociatedAppointment(True) If Not Appt Is Nothing Then Appt.ReminderSet = True Appt.ReminderMinutesBeforeStart = 15 Appt.Save End If End If End Sub Thx, JP On Nov 1, 2:14 am, "Michael Bauer [MVP - Outlook]" wrote: ReminderMinutesBeforeStart and Reminderset=true should be fine. Then save the item. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Synchronize Color Categories & Ensure that Every Item Gets Categorized: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Wed, 31 Oct 2007 14:20:57 -0000 schrieb JP: |
|
#6
|
|||
|
|||
|
First, you might check if the code runs at all. Place the cursor e.g. on the Items_ItemAdd line and press f9 for a breakpoint. If you then receive another item the code execution should stop at that line. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Synchronize Color Categories & Ensure that Every Item Gets Categorized: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Fri, 02 Nov 2007 01:04:25 -0000 schrieb JP: Hi again, I tried it and it doesn't seem to work. I asked someone to send a meeting request without a reminder. After I accept, I check the appointment on the calendar and there's no reminder. Could there be a delay before the reminder appears? Here's the code I used. Private WithEvents Items As Outlook.Items Private Sub Application_Startup() Dim Ns As Outlook.NameSpace Set Ns = Application.GetNamespace("MAPI") Set Items = Ns.GetDefaultFolder(olFolderInbox).Items End Sub Private Sub Items_ItemAdd(ByVal Item As Object) On Error Resume Next Dim Meet As Outlook.MeetingItem Dim Appt As Outlook.AppointmentItem If TypeOf Item Is Outlook.MeetingItem Then Set Meet = Item Meet.ReminderSet = True Meet.Save Set Appt = Meet.GetAssociatedAppointment(True) If Not Appt Is Nothing Then Appt.ReminderSet = True Appt.ReminderMinutesBeforeStart = 15 Appt.Save End If End If End Sub Thx, JP On Nov 1, 2:14 am, "Michael Bauer [MVP - Outlook]" wrote: ReminderMinutesBeforeStart and Reminderset=true should be fine. Then save the item. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Synchronize Color Categories & Ensure that Every Item Gets Categorized: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Wed, 31 Oct 2007 14:20:57 -0000 schrieb JP: |
|
#7
|
|||
|
|||
|
Tried that, it doesn't work. The event doesn't fire at all.
--JP On Nov 2, 2:15 am, "Michael Bauer [MVP - Outlook]" wrote: First, you might check if the code runs at all. Place the cursor e.g. on the Items_ItemAdd line and press f9 for a breakpoint. If you then receive another item the code execution should stop at that line. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Synchronize Color Categories & Ensure that Every Item Gets Categorized: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 |
|
#8
|
|||
|
|||
|
Ok, then go to Tools/macro/Security and allow VBA to be executed. Then restart Outlook. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Synchronize Color Categories & Ensure that Every Item Gets Categorized: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 Am Fri, 02 Nov 2007 18:50:06 -0000 schrieb JP: Tried that, it doesn't work. The event doesn't fire at all. --JP On Nov 2, 2:15 am, "Michael Bauer [MVP - Outlook]" wrote: First, you might check if the code runs at all. Place the cursor e.g. on the Items_ItemAdd line and press f9 for a breakpoint. If you then receive another item the code execution should stop at that line. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook Synchronize Color Categories & Ensure that Every Item Gets Categorized: http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6 |
|
#9
|
|||
|
|||
|
Brilliant! It works now. I was updating the code but didn't close and
restart Outlook before testing. Thanks for your assistance. Thx, JP On Nov 3, 2:47 am, "Michael Bauer [MVP - Outlook]" wrote: Ok, then go to Tools/macro/Security and allow VBA to be executed. Then restart Outlook. -- |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Day missing from Meeting Requests | me@henderson1977.plus.com | Outlook - General Queries | 0 | December 22nd 06 03:33 PM |
| meeting reminder doesn't follow rescheduled meeting | The Burgess Family | Outlook - Calandaring | 0 | September 7th 06 07:48 PM |
| Missing meeting requests | Roide | Outlook - Calandaring | 3 | August 24th 06 05:38 AM |
| appointment reminder missing | wrlang1977 | Outlook - Calandaring | 0 | July 27th 06 03:43 PM |
| Add Reminder To Incoming Meeting Requests | Joseph Rees | Outlook and VBA | 5 | March 7th 06 06:49 PM |