A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Programmatically add reminder (if missing) to meeting requests



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old October 30th 07, 08:39 PM posted to microsoft.public.outlook.program_vba
JP[_2_]
external usenet poster
 
Posts: 18
Default Programmatically add reminder (if missing) to meeting requests

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  
Old October 31st 07, 05:40 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Programmatically add reminder (if missing) to meeting requests



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  
Old October 31st 07, 02:20 PM posted to microsoft.public.outlook.program_vba
JP[_2_]
external usenet poster
 
Posts: 18
Default Programmatically add reminder (if missing) to meeting requests

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  
Old November 1st 07, 06:14 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Programmatically add reminder (if missing) to meeting requests




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  
Old November 2nd 07, 01:04 AM posted to microsoft.public.outlook.program_vba
JP[_2_]
external usenet poster
 
Posts: 18
Default Programmatically add reminder (if missing) to meeting requests

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  
Old November 2nd 07, 06:15 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Programmatically add reminder (if missing) to meeting requests



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  
Old November 2nd 07, 06:50 PM posted to microsoft.public.outlook.program_vba
JP[_2_]
external usenet poster
 
Posts: 18
Default Programmatically add reminder (if missing) to meeting requests

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  
Old November 3rd 07, 07:47 AM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default Programmatically add reminder (if missing) to meeting requests



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  
Old November 5th 07, 06:30 PM posted to microsoft.public.outlook.program_vba
JP[_2_]
external usenet poster
 
Posts: 18
Default Programmatically add reminder (if missing) to meeting requests

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 Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Day missing from Meeting Requests [email protected] Outlook - General Queries 0 December 22nd 06 02:33 PM
meeting reminder doesn't follow rescheduled meeting The Burgess Family Outlook - Calandaring 0 September 7th 06 06:48 PM
Missing meeting requests Roide Outlook - Calandaring 3 August 24th 06 04:38 AM
appointment reminder missing wrlang1977 Outlook - Calandaring 0 July 27th 06 02:43 PM
Add Reminder To Incoming Meeting Requests Joseph Rees Outlook and VBA 5 March 7th 06 05:49 PM


All times are GMT +1. The time now is 03:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.