Sort in Address Book by Company, not Last Name nor First Name

[Pam H]

Is there a way that I can have contacts appear in the Address Book by Company, not by Last Name nor First Name?

Thanks!

 

[Sue Mosher [MVP-Outlook]]

Outlook version?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Is there a way that I can have contacts appear in the Address Book by

Company, not by Last Name nor First Name?

 

[Sue Mosher [MVP-Outlook]]

Repeating: And the version of Outlook that you're using is?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

No, that LAME windows address book version that appears when you click on

the Address Book icon in Word, Outlook, Excel, etc.

 

[Pam H]

OUTLOOK 2003.

No, that LAME windows address book version that appears when you click on the Address Book icon in Word, Outlook, Excel, etc.

 

[Pam H]

Outlook 2003 ( I answered above in a separate post).

 

[Sue Mosher [MVP-Outlook]]

Word 2003 and Outlook 2003 show different address books. Outlook's allows
you either to display names in First Last order or to use the File As field,
which can show anything you want, including the company name. The hitch is
that the File As field is populated when you save the item. So, if you don't
already have the Company field stored as part of the File As field, you'll
have to either change all your contacts manually or run a VBA macro.

So the first steps are to set up your default File As field to include the
Company and to display the Address Book in File As order.

To set the File As default:

1) Choose Tools | Options | Contact options.
2) Make your choice from the Default "File As" Order list.
3) Click OK to save changes.

To use File As order in the address book:

1) Choose Tools | E-mail accounts and then choose "View or change existing
directories or address books."
2) From the Directories and Address Books list, choose Outlook Address Book,
and then click Change.
3) In the Outlook Address Book dialog, under "Show names by," choose File
As.

Let me know if you need a VBA code snippet to change the File As property
for your existing contacts.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Pam H]

Thanks for your help -- I've already checked Company, I don't think I need a VBA code.

I can't help but ask "Why?" Why the "H" does Word & Outlook use different address books? Jeez, what's MS thinking? One Address Book for all! So what address book am I using in Word? Is that the LAME Windows Address Book or what -- the one you can't work with?

 

[Sue Mosher [MVP-Outlook]]

It's a mystery to us, too. It's like Word and Outlook were designed by
totally different teams.

Word has its own address book to show Outlook data. The Windows Address Book
is part of Outlook Express.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Thanks for your help -- I've already checked Company, I don't think I need a VBA code.

I can't help but ask "Why?" Why the "H" does Word & Outlook use different

address books? Jeez, what's MS thinking? One Address Book for all! So
what address book am I using in Word? Is that the LAME Windows Address Book
or what -- the one you can't work with?

 

[Sherry K]

Yes. Open the contact, click the drop down arrow for
File As, select the company name (or other choice you
prefer), click Save and Close.

-----Original Message-----
Is there a way that I can have contacts appear in the

Address Book by Company, not by Last Name nor First Name?