asked on
appointments from tasks - advanced filter/view
Dear Experts,
you can create appointment in calendar from task (by draggisk task to calendar).
If you create such appointent, does the appointment object contains some reference to the source task?
can you for example prepare and SQL filter (view) showing only those tasks which have a corresponding appointment in calendar?
thanks
Jarek
you can create appointment in calendar from task (by draggisk task to calendar).
If you create such appointent, does the appointment object contains some reference to the source task?
can you for example prepare and SQL filter (view) showing only those tasks which have a corresponding appointment in calendar?
thanks
Jarek
OutlookMicrosoft Office
Last Comment
David Lee
SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Yep, you can. Using MS Office for project management is an enhancement found in 2010. Have a peek: http://gigaom.com/2009/09/23/5-outlook-2010-productivity-enhancements/
ASKER
Unfortunately I cannot find what I need in the arcticle you provided, cityqat.
Can you please be more specific?
or maybe other Expert could help?
I need a way to display tasks (maybe using SQL filter) from which there are no appointments created in Calendar.
Otherwise I will follow Julian123 advice.
thanks!
Jarek
Can you please be more specific?
or maybe other Expert could help?
I need a way to display tasks (maybe using SQL filter) from which there are no appointments created in Calendar.
Otherwise I will follow Julian123 advice.
thanks!
Jarek
Hi, ja-rek.
What do you have in mind when you say "display tasks"? As Julian123 said, we can use VBA to search the calendar for tasks with subjects matching those of tasks. There's no built-in way of displaying that in Outlook though. In other words, we can't filter your task list to show just those tasks with calendar appointments. We could display that info in a dialog-box, send it to Excel, or something like that.
Julian123 also pointed out an obvious flaw in this kind of search. All we can match on is the subject. That's going to provide inaccurate results since it's entirely possible that there will be appointments with subjects that match tasks even though that appointment wasn't created by dragging and dropping the task to the calendar.
Perhaps if you could share what you need to accomplish we could recommend a solution.
What do you have in mind when you say "display tasks"? As Julian123 said, we can use VBA to search the calendar for tasks with subjects matching those of tasks. There's no built-in way of displaying that in Outlook though. In other words, we can't filter your task list to show just those tasks with calendar appointments. We could display that info in a dialog-box, send it to Excel, or something like that.
Julian123 also pointed out an obvious flaw in this kind of search. All we can match on is the subject. That's going to provide inaccurate results since it's entirely possible that there will be appointments with subjects that match tasks even though that appointment wasn't created by dragging and dropping the task to the calendar.
Perhaps if you could share what you need to accomplish we could recommend a solution.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
thanks Bluedevil for reply.
I would like to know which of my tasks have not been scheduled in calendar as appointments
I would like to know which of my tasks have not been scheduled in calendar as appointments
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionASKER
many thanks!
You're welcome!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.