|
| 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. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
November 13th 09, 03:09 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Outlook Appointment recurrence setting
Hi All,
I am working on an automation project to send recurrent meeting requests from an Excel file on. Everything works fine for weekly, monthly and monthNth recurrent meetings. Also daily recurrent meetings are OK but the thing I don't see is how to specify that 'every weekday' option has to be used. I'm usiing Office/Oulook 2003. Part of my code: Select Case golRecurrenceInfo.Occurence Case olRecursDaily olRecurrencePattern.RecurrenceType = olRecursDaily olRecurrencePattern.Interval = golRecurrenceInfo.Interval Case olRecursWeekly olRecurrencePattern.RecurrenceType = olRecursWeekly olRecurrencePattern.Interval = golRecurrenceInfo.Interval golRecurrenceInfo.Interval is an intenal variable containing the recurrency info. I would be grateful for any help. Wkr, JP 
|
| Ads |
|
#2
November 13th 09, 05:05 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Outlook Appointment recurrence setting
As I remember, you need to write the days into the DayOfWeekMask property. -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : http://www.vboffice.net/product.html?pub=6&lang=en Am Fri, 13 Nov 2009 16:09:47 +0100 schrieb JP Ronse: Hi All, I am working on an automation project to send recurrent meeting requests from an Excel file on. Everything works fine for weekly, monthly and monthNth recurrent meetings. Also daily recurrent meetings are OK but the thing I don't see is how to specify that 'every weekday' option has to be used. I'm usiing Office/Oulook 2003. Part of my code: Select Case golRecurrenceInfo.Occurence Case olRecursDaily olRecurrencePattern.RecurrenceType = olRecursDaily olRecurrencePattern.Interval = golRecurrenceInfo.Interval Case olRecursWeekly olRecurrencePattern.RecurrenceType = olRecursWeekly olRecurrencePattern.Interval = golRecurrenceInfo.Interval golRecurrenceInfo.Interval is an intenal variable containing the recurrency info. I would be grateful for any help. Wkr, JP
|
|
#3
November 13th 09, 09:49 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Outlook Appointment recurrence setting
Monday...Friday = 62
-- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Michael Bauer [MVP - Outlook]" wrote in message .. . As I remember, you need to write the days into the DayOfWeekMask property. -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : http://www.vboffice.net/product.html?pub=6&lang=en Am Fri, 13 Nov 2009 16:09:47 +0100 schrieb JP Ronse: Hi All, I am working on an automation project to send recurrent meeting requests from an Excel file on. Everything works fine for weekly, monthly and monthNth recurrent meetings. Also daily recurrent meetings are OK but the thing I don't see is how to specify that 'every weekday' option has to be used. I'm usiing Office/Oulook 2003. Part of my code: Select Case golRecurrenceInfo.Occurence Case olRecursDaily olRecurrencePattern.RecurrenceType = olRecursDaily olRecurrencePattern.Interval = golRecurrenceInfo.Interval Case olRecursWeekly olRecurrencePattern.RecurrenceType = olRecursWeekly olRecurrencePattern.Interval = golRecurrenceInfo.Interval golRecurrenceInfo.Interval is an intenal variable containing the recurrency info. I would be grateful for any help. Wkr, JP
|
|
#4
November 14th 09, 11:00 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Outlook Appointment recurrence setting
Hi Michael,
Thanks for your help. You are right. Meanwhile I was able to figure out that I had to use 62 as DayOfWeekMask to point to every weekday (Mon to Fri). Wkr, JP "Michael Bauer [MVP - Outlook]" wrote in message .. . As I remember, you need to write the days into the DayOfWeekMask property. -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : http://www.vboffice.net/product.html?pub=6&lang=en Am Fri, 13 Nov 2009 16:09:47 +0100 schrieb JP Ronse: Hi All, I am working on an automation project to send recurrent meeting requests from an Excel file on. Everything works fine for weekly, monthly and monthNth recurrent meetings. Also daily recurrent meetings are OK but the thing I don't see is how to specify that 'every weekday' option has to be used. I'm usiing Office/Oulook 2003. Part of my code: Select Case golRecurrenceInfo.Occurence Case olRecursDaily olRecurrencePattern.RecurrenceType = olRecursDaily olRecurrencePattern.Interval = golRecurrenceInfo.Interval Case olRecursWeekly olRecurrencePattern.RecurrenceType = olRecursWeekly olRecurrencePattern.Interval = golRecurrenceInfo.Interval golRecurrenceInfo.Interval is an intenal variable containing the recurrency info. I would be grateful for any help. Wkr, JP
|
|
#5
November 14th 09, 11:04 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Outlook Appointment recurrence setting
Hi Dimitry,
Thanks for your help. Indeed it is 62. I was able to figure it out with some other code I have already in use. If I had a look to all constants and not only to olSunday & olMonday, I would have seen that Sun =1, Mon =2... Sat =64 and not the usual values 1 to 7. Wkr, JP "Dmitry Streblechenko" wrote in message ... Monday...Friday = 62 -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Michael Bauer [MVP - Outlook]" wrote in message .. . As I remember, you need to write the days into the DayOfWeekMask property. -- Best regards Michael Bauer - MVP Outlook : Outlook Categories? Category Manager Is Your Tool : VBOffice Reporter for Data Analysis & Reporting : http://www.vboffice.net/product.html?pub=6&lang=en Am Fri, 13 Nov 2009 16:09:47 +0100 schrieb JP Ronse: Hi All, I am working on an automation project to send recurrent meeting requests from an Excel file on. Everything works fine for weekly, monthly and monthNth recurrent meetings. Also daily recurrent meetings are OK but the thing I don't see is how to specify that 'every weekday' option has to be used. I'm usiing Office/Oulook 2003. Part of my code: Select Case golRecurrenceInfo.Occurence Case olRecursDaily olRecurrencePattern.RecurrenceType = olRecursDaily olRecurrencePattern.Interval = golRecurrenceInfo.Interval Case olRecursWeekly olRecurrencePattern.RecurrenceType = olRecursWeekly olRecurrencePattern.Interval = golRecurrenceInfo.Interval golRecurrenceInfo.Interval is an intenal variable containing the recurrency info. I would be grateful for any help. Wkr, JP
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Default calendar setting always creats a weekly recurrence. | TACO | Outlook - Calandaring | 1 | October 3rd 07 08:07 PM |
| Outlook 2002 - Appointment Recurrence | Hamez | Outlook - Calandaring | 0 | December 13th 06 03:17 PM |
| Setting a Reminder on events with a Yearly Recurrence pattern | Daniel Smith | Outlook - Calandaring | 0 | May 7th 06 02:00 PM |
| How do I stop 'Recurrence' from the default setting of 'Birthday'? | TheScenicRoute | Outlook - Using Contacts | 0 | May 2nd 06 09:47 PM |
| Outlook appointment recurrence patterns | slb0m | Outlook - Calandaring | 1 | February 16th 06 11:40 PM |
Linear Mode
