?
Solved

Recurring Appointments - Excluding Weekends

Posted on 2007-11-19
5
Medium Priority
?
6,145 Views
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?
0
Comment
Question by:mgiller
[X]
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
5 Comments
 
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.

Chris
0
 

Author Comment

by:mgiller
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?
0
 
LVL 59

Expert Comment

by:Chris Bottomley
ID: 20462778
Ah!

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.

Chris
0
 
LVL 59

Accepted Solution

by:
Chris Bottomley earned 375 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.

Chris
0
 

Author Comment

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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
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…
Suggested Courses

762 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