 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / December 2007Search with categories in outlook
I've one category rec07x for those from whom I've received a christmas card, and another category sent07 for those to whom I've sent one. How can I retrieve those from whom I've received but haven't sent? Group By Category and there will be some people that only show in the rec'd Category group. This is due to Categories being a multivalued field ie someone can be in more than one Category so others will show in sent an rec'd groups. Make sure to sort by name before you group by Category so it's easier to compare the groups. If comparing is too difficult 'cause the numbers are huge, you could try a filtered View of the Contact folder. Add the criteria you need and it will filter it for you. BTW you forgot to mention your version and their are some quirks that are version specific! Here are some tips about how to post questions: http://support.microsoft.com/?id=555375 Regards Judy Gleeson MVP Outlook Trainer and Consultant There are various articles about using Outlook here: www.judygleeson.com Canberra, Australia "What do we live for, if it is not to make life less difficult for each other?" George Eliot > I've one category rec07x for those from whom I've received a christmas > card, > and another category sent07 for those to whom I've sent one. > How can I retrieve those from whom I've received but haven't sent? Thanks judy, I'm on Office 2007 outlook. Trying to overcome colors and categories. BTW Managed to delete 100+ contacts last night when I tried to remove a category - received06 - it removed all the contacts not just the category! Thank goodness for Plaxo which was able to provide a back-up! (between phone, laptop and microsoft exchange - they all decided to implement to accidental deletion without saying anything! I've found your rather dense notes on things to do with outlook categories so I'll try to follow some of those before my bad word of mouth hits microsoft outlook.... > Group By Category and there will be some people that only show in the rec'd > Category group. This is due to Categories being a multivalued field ie [quoted text clipped - 30 lines] > > and another category sent07 for those to whom I've sent one. > > How can I retrieve those from whom I've received but haven't sent? if you accidentally delete anything, go straight to the Deleted Items folder and drag it back to its relevant folder. Regards Judy Gleeson MVP Outlook Trainer and Consultant There are various articles about using Outlook here: www.judygleeson.com Canberra, Australia "What do we live for, if it is not to make life less difficult for each other?" George Eliot > Thanks judy, I'm on Office 2007 outlook. Trying to overcome colors and > categories. [quoted text clipped - 45 lines] >> > and another category sent07 for those to whom I've sent one. >> > How can I retrieve those from whom I've received but haven't sent? The SQL filter would be like this: "urn:schemas-microsoft-com:office:office#Keywords" LIKE 'rec07' AND NOT "urn:schemas-microsoft-com:office:office#Keywords" LIKE 'sent07'  SignatureBest regards Michael Bauer - MVP Outlook The Tool for Outlook Categories: <http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6> Am Thu, 20 Dec 2007 10:32:06 +1100 schrieb Judy Gleeson (MVP Outlook): > Group By Category and there will be some people that only show in the rec'd > Category group. This is due to Categories being a multivalued field ie [quoted text clipped - 30 lines] >> and another category sent07 for those to whom I've sent one. >> How can I retrieve those from whom I've received but haven't sent? This is getting to look like it will work. What would be good is to be able to access such SQL filter logic when I'm trying to include these from mailmerge within Word 2007, when I'm generating those pesky Xmas newsletters and labels! Then we can write this up as a feature for how to organise your christmas cards using word and outlook - sounds like it might be a microsoft at work newsletter article (my newsletter just arrived!) > The SQL filter would be like this: > [quoted text clipped - 37 lines] > >> and another category sent07 for those to whom I've sent one. > >> How can I retrieve those from whom I've received but haven't sent? I think you should just send your cards at the end of November to EVERYONE in your Contacts and then you don't have to bother with these calculations! Regards Judy Gleeson MVP Outlook Trainer and Consultant There are various articles about using Outlook here: www.judygleeson.com Canberra, Australia "What do we live for, if it is not to make life less difficult for each other?" George Eliot > This is getting to look like it will work. > What would be good is to be able to access such SQL filter logic when I'm [quoted text clipped - 50 lines] >> >> and another category sent07 for those to whom I've sent one. >> >> How can I retrieve those from whom I've received but haven't sent? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.