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

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
  • 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying 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

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) 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…

861 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