Solved

Recurring Appointments - Excluding Weekends

Posted on 2007-11-19
5
5,357 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
  • 3
  • 2
5 Comments
 
LVL 59

Expert Comment

by:Chris Bottomley
Comment Utility
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
Comment Utility
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
Comment Utility
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 125 total points
Comment Utility
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
Comment Utility
Ah, well--it was worth a try!  Thanks for looking into this, though.  I appreciate the help!
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Email signatures have numerous marketing benefits. Here are 8 top reasons to turn your email signature into a marketing channel.
If you don't know how to downgrade, my instructions below should be helpful.
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 …
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: …

744 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now