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

RE: Contact filtering by Matt

Matt
Wed Jun 11 11:22:02 PDT 2008

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

"Matt" wrote:

> 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

Re: Contact filtering by Michael

Michael
Wed Jun 11 12:52:43 PDT 2008


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:

> 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

Re: Contact filtering by Matt

Matt
Wed Jun 11 13:43:01 PDT 2008

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]" wrote:

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

Re: Contact filtering by Michael

Michael
Wed Jun 11 22:25:24 PDT 2008



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:

> 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]" wrote:
>
>>
>> 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:
>>
>>> 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
>>

Re: Contact filtering by Judy

Judy
Wed Jun 11 22:57:40 PDT 2008

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.

.
"Michael Bauer [MVP - Outlook]" <mb@mvps.org> wrote in message
news:1894hzfngg8r$.1irkciomavbab.dlg@40tude.net...
>
>
> 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:
>
>> 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]" wrote:
>>
>>>
>>> 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:
>>>
>>>> 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
>>>