|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
December 19th 07, 08:27 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Search 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? 
|
|
#2
December 19th 07, 11:32 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Search with categories in 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 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 he www.judygleeson.com Canberra, Australia "What do we live for, if it is not to make life less difficult for each other?" George Eliot "Dr Stephen K Tagg" wrote in message ... 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?
|
|
#3
December 19th 07, 11:49 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Search with categories in outlook
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.... "Judy Gleeson (MVP Outlook)" wrote: 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 he www.judygleeson.com Canberra, Australia "What do we live for, if it is not to make life less difficult for each other?" George Eliot "Dr Stephen K Tagg" wrote in message ... 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?
|
|
#4
December 20th 07, 12:46 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Search with categories in outlook
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 he www.judygleeson.com Canberra, Australia "What do we live for, if it is not to make life less difficult for each other?" George Eliot "Dr Stephen K Tagg" wrote in message ... 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.... "Judy Gleeson (MVP Outlook)" wrote: 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 he www.judygleeson.com Canberra, Australia "What do we live for, if it is not to make life less difficult for each other?" George Eliot "Dr Stephen K Tagg" wrote in message ... 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?
|
|
#5
December 20th 07, 08:35 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Search with categories in outlook
The SQL filter would be like this: "urn:schemas-microsoft-com  fficeffice#Keywords" LIKE 'rec07' ANDNOT "urn:schemas-microsoft-com fficeffice#Keywords" LIKE 'sent07' -- Best 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 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 he www.judygleeson.com Canberra, Australia "What do we live for, if it is not to make life less difficult for each other?" George Eliot "Dr Stephen K Tagg" wrote in message ... 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?
|
|
#6
December 20th 07, 12:29 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Search with categories in outlook
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!) "Michael Bauer [MVP - Outlook]" wrote: The SQL filter would be like this: "urn:schemas-microsoft-com fficeffice#Keywords" LIKE 'rec07' ANDNOT "urn:schemas-microsoft-com fficeffice#Keywords" LIKE 'sent07' -- Best 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 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 he www.judygleeson.com Canberra, Australia "What do we live for, if it is not to make life less difficult for each other?" George Eliot "Dr Stephen K Tagg" wrote in message ... 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?
|
|
#7
December 21st 07, 12:02 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Search with categories in outlook
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 he www.judygleeson.com Canberra, Australia "What do we live for, if it is not to make life less difficult for each other?" George Eliot "Dr Stephen K Tagg" wrote in message ... 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!) "Michael Bauer [MVP - Outlook]" wrote: The SQL filter would be like this: "urn:schemas-microsoft-com fficeffice#Keywords" LIKE 'rec07' ANDNOT "urn:schemas-microsoft-com fficeffice#Keywords" LIKE 'sent07'-- Best 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 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 he www.judygleeson.com Canberra, Australia "What do we live for, if it is not to make life less difficult for each other?" George Eliot "Dr Stephen K Tagg" wrote in message ... 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?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook 2007 Categories are a combo of Categories & Labels in 2003 | Scott Sherman | Outlook - Calandaring | 0 | February 13th 07 04:23 AM |
| Boolean search - Categories | Jack | Outlook - Using Contacts | 2 | December 17th 06 04:07 PM |
| Outlook should allow a search of categories using a drop down box | Randall Berinhout | Outlook - Using Contacts | 1 | August 27th 06 10:05 PM |
| Search folder with no categories in O2003? | [email protected] | Outlook - General Queries | 2 | June 16th 06 07:41 AM |
| categories are all open after a search in my contacts | Eddie | Outlook - Using Contacts | 3 | March 31st 06 11:38 AM |
Hybrid Mode
