Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Monthly Business Day Recurrence (Outlook 2000)

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

    Thanks
    Christine
    thanks
    christine

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Monthly Business Day Recurrence (Outlook 2000)

    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 <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

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

  3. #3
    5 Star Lounger
    Join Date
    Dec 2002
    Location
    Perth, Western Australia, Australia
    Posts
    730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Monthly Business Day Recurrence (Outlook 2000)

    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' <img src=/S/grin.gif border=0 alt=grin width=15 height=15> depending on your preferred calendar view.
    <font face="Comic Sans MS" color="blue">TimOz</font>
    <img src=/S/flags/Finland.gif border=0 alt=Finland width=30 height=18> <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  4. #4
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Monthly Business Day Recurrence (Outlook 2000)

    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 <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    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.

  5. #5
    5 Star Lounger
    Join Date
    Dec 2002
    Location
    Perth, Western Australia, Australia
    Posts
    730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Monthly Business Day Recurrence (Outlook 2000)

    Fair enough point, it's just that sometimes you have to put in some serious work to to be truly lazy <img src=/S/grin.gif border=0 alt=grin width=15 height=15> .

    Actually, I forgot we were dealing with a recurring appointment <img src=/S/woops.gif border=0 alt=woops width=58 height=36> . 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 <img src=/S/doh.gif border=0 alt=doh width=15 height=15> .
    <font face="Comic Sans MS" color="blue">TimOz</font>
    <img src=/S/flags/Finland.gif border=0 alt=Finland width=30 height=18> <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •