Macro to create repeating calender event/meeting

[Guest]

I'm looking to create a repeating meeting with a slightly odd repition cycle.

What I need is a meeting that falls on the last friday of every month IF the
last day of the month falls on a Friday - Tuesday.

If, however, the last day of the month falls on a wednesday or Thursday, I
need the meeting to occur on the First friday of the following month.

I know this would be easy enough to set up manually, one month at a time,
but the problem is that I need to do this at least five years into the
future. (Don't ask why, not my decision)

Is there any way I can do this via a macro / VBA, or am I doomed to spend a
morning devoted to making Outlook meetings?

 

[Guest]

Sorry, should note I'm using Outlook 2003. I'm sure that will have an effect
of some sort.

 

[Ken Slovak - [MVP - Outlook]]

Unfortunately the RecurrencePattern binary doesn't support that complex a
recurrence. If you can't create it in the UI you can't create it in code.
Version of Outlook doesn't matter, the RecurrencePattern binary hasn't
changed since Schedule+.

 

[Guest]

Hmm... well, would there be a way to work around it if I didn't need the
meetings all to be a true "series"? I was thinking something along the lines
of:

With (all months between date and date2)
If (month ends on fri/sat/sun/mon/tues) then
Create new meeting on last friday of month
Else if (month ends on a wednesday/thursday)
goto new month
Create new meeting on first friday of month
End if
End With

All I really need are for the meeting discriptions the same, whether they
are all linked doesn't matter. Sadly, I don't know the know the code well
enough to attempt this sort of thing on my own.

Thanks for your help!

 

[Ken Slovak - [MVP - Outlook]]

Play with it in the UI and create the combination of recurring items you
need. Then you can use their RecurrencePattern properties to do what you
want. It's a nice empirical way to learn the recurrence pattern oddities.