Search with categories in outlook

[Dr Stephen K Tagg]

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?

 

[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 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

 

[Dr Stephen K Tagg]

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\)]

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

 

[Michael Bauer [MVP - Outlook]]

The SQL filter would be like this:

"urn:schemas-microsoft-comfficeffice#Keywords" LIKE 'rec07' AND
NOT "urn:schemas-microsoft-comfficeffice#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):

 

[Dr Stephen K Tagg]

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!)

 

[Judy Gleeson \(MVP 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 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