Outlook Appointment recurrence setting

  • Thread starter Thread starter JP Ronse
  • Start date Start date
J

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
 
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 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
 
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
 
Back
Top