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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
Changing a few Outlook Options can help keep you organized!
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 …
CodeTwo Sync for iCloud ( automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

739 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