Recurring Appointments - Excluding Weekends

Posted on 2007-11-19
Last Modified: 2008-02-01
A user of mine had an interesting question that I've not come across in my years of using Outlook.  She wants to create a recurring appointment as a reminder to occur on the 15th of each month, which is easy enough--but she wants to exclude the date if it happens to fall on a weekend, and instead have it occur on the last weekday before.

For example:  if the 15th falls on a Saturday or a Sunday, she'd like the appointment (and it's reminder) to fire off on the preceding Friday.  Is such a thing even possible?
Question by:mgiller
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 59

Expert Comment

by:Chris Bottomley
ID: 20459508
Not familiar with 2002, but in 2003 although the requested functionality is not supported a similar functionality could be achieved by setting the recurrence to be monthly on the 12th weekday of the month  this would nominally fall around the 15th but definitely a working day.  A quick check will show if the same similar option exists for 2002, but as far as I can see it exists for 2002 as well as 2003.


Author Comment

ID: 20460195
Hey, Chris...  Thanks for the tip!  I did notice a limitation with using this recurrence pattern, though--in both Oytlook 2003 and 2002, you're limited to the first, second, third, fourth or last weekday in any month.  The drop-down doesn't give you the option to enter a value manually, either.  Is there a way around this so that I could specify the 12th weekday of every month?
LVL 59

Expert Comment

by:Chris Bottomley
ID: 20462778

I apologise I clearly didn't check the detail properly, I didn't know that 1..4, last was the limitation there, (I normally use the first or last).  I should have checked it fully met your wishes before responding.  Weeks are clearly not an option as they give 13 4 week months.

Next best may be a macro to enter individual dates, but that will mean they cannot be edited as a series ... i.e. if timing or text changes you would have to edit each individual one.

LVL 59

Accepted Solution

Chris Bottomley earned 125 total points
ID: 20463034
I have created a routine to insert an appt from VBA but it has the same limitations, (and the vba definitions support this) in that only the 1 ... 5th working days are supported.

I don't think it can done because outlook limits the recurrence, there are a few add-ins out there but none of them that I have seen indicate a capability of this type either.


Author Comment

ID: 20464173
Ah, well--it was worth a try!  Thanks for looking into this, though.  I appreciate the help!

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question