Monthly Business Day Recurrence (Outlook 2000)

Topic

New Reply

How can I setup a recurrence based on an appointment occurring every 7th business day of the month?

Thanks
Christine

Reply | Quote

Replies

Christine

Best you could do is schedule a ‘marker’ appointment for the second workingday of the month and then drag each meeting one week later

Recurring appointments (by design) will not go beyond working day five – even with VBA code.

Reply | Quote

Andrew, is it possible to extend on your suggestion? That is, write VBA to ‘drag’ the meeting a week into the future, for you. It could be linked to in the ‘marker’ appointment, or added to the appointment toolbar. Such a macro could be useful in a more generic form to move any appointment X days (weeks/months) forward (or back).

The manual drag will work OK, but may be a ‘drag’ depending on your preferred calendar view.

Reply | Quote

Tim

Yes it is probably possible but I haven’t attempted it.

It is not trivial because a recurring appointment has to be varied one-by one based on its ‘rule’ and there is also no obvious end point. Nor is there an easy way to handle possible holidays in the week following.

My estimate is that it would take about five minutes to drag two years of appointments (handling holidays on the fly) – about three hours to write code to do the same. An interesting excercise admittedly, but not a good ROI

An alternative manual method that works very well is to create a ‘first’ meeting, then simply ctrl-drag it to the next month – again, a fairly quick undertaking.

Reply | Quote

Fair enough point, it’s just that sometimes you have to put in some serious work to to be truly lazy .

Actually, I forgot we were dealing with a recurring appointment . What I envisaged was just getting the date of the ‘marker’ appointment, and updating that. But, as you point out, it’s a tad more complex than that .

Reply | Quote