Contact filtering

[Matt]

Does anyone know if there is a way to create a contact view in Outlook 2007
that is filtered by the first letter of either the last name field or the
file as field. I used to use tabview organizer, and their tech support and I
worked out SQL code (for the SQL tab) that allowed for this in their product,
but they have not been able to get it to work properly with Outlook 2007, so
I have lost the functionality since I upgraded.

I have 34000 contacts in Outlook, and it would be great to be able to only
look at a smaller list (by letter), rather than having to scroll through all
34000 contacts every time I need to find someone.

Also, (and this is probably for the 3rd party addons discussion group, but
someone might know) does anyone know of an addon similiar to 2007, that
allows for multiple views to be overlapped (Tabview allowed me to create a
view, i.e. "clients", using the built in view creator, and, then further
filter the list by each letter of the last name, thus I could switch between
clients and colleagues (2 different views), and then narrow the results
(using a seperate view selector) to all people who's last name begins with
each letter, thus I could very quickly sort through and find a contact within
such a long list

 

[Matt]

Added Note, I have tried using wild cards on the Advanced tab of filtering
("*", "?", etc) without any luck

 

[Michael Bauer [MVP - Outlook]]

In the filter dialog, you may set to look for 'a' in FileAs on the first
tab. Then switch to the SQL tab, check 'Edit criteria directly', and change
LIKE '%a%' to LIKE 'a%'.

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool:
: <http://www.vboffice.net/product.html?pub=6&lang=en>



Am Wed, 11 Jun 2008 11:14:00 -0700 schrieb Matt:

 

[Matt]

perfect, that worked.

But, it was a lot more convenient when I had a set of alphabet buttons (from
when I was using tabview organizer). Do you know of any other addins that
might work to create that, and/or is there a way to modify the alphabet
buttons that are already included in Outlook (the row down the left side) so
that instead of simply moving to the first contact that begins wihth the
letter selected, it actually filters out all of the other contacts?

 

[Michael Bauer [MVP - Outlook]]

No.

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool:
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 11 Jun 2008 13:43:01 -0700 schrieb Matt:

 

[Judy Gleeson \(MVP Outlook\)]

dumb question time...

what's wrong with using the Contact lookup window?

you want Graeme Johnston so you type GRA JO and Enter. It finds him quite
quickly. I've used this with 18,000 contacts.

--

Regards

Judy Gleeson
MVP Outlook
Trainer and Consultant www.pragmatix.com.au
Outlook 2003 user? Read "7 settings all Outlook 2003 users should change"
on my website.

..