Importing Excel to sort as Company

[Guest]

When importing my Excel contacts into Outlook Contacts, all my contacts are
sorted by last name. I want them to be sorted by Company. I tried setting
the default for filing new contacts to Company, moving the Company column to
the first column in the Excel spreadsheet, and sorting the Excel spreadsheet
by the Company. Unfortunately, I have to update six different peoples
contacts in this manner and and everyone wants them sorted by Company. Any
suggestions?

Thank you.

 

[Russ Valentine [MVP-Outlook]]

Sorting preferences do not apply to imported Contacts.

 

[Guest]

Does this mean that I'll have to go into each individual contact and change
the "File as" from last name to Company? Each person has over 1,000 contacts.

Thanks.

Sorting preferences do not apply to imported Contacts.
--
Russ Valentine
[MVP-Outlook]

When importing my Excel contacts into Outlook Contacts, all my contacts
are
sorted by last name. I want them to be sorted by Company. I tried
setting
the default for filing new contacts to Company, moving the Company column
to
the first column in the Excel spreadsheet, and sorting the Excel
spreadsheet
by the Company. Unfortunately, I have to update six different peoples
contacts in this manner and and everyone wants them sorted by Company.
Any
suggestions?

Thank you.

 

[Russ Valentine [MVP-Outlook]]

Or use code to do it:
http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002

--
Russ Valentine
[MVP-Outlook]

Does this mean that I'll have to go into each individual contact and
change
the "File as" from last name to Company? Each person has over 1,000
contacts.

Thanks.

Sorting preferences do not apply to imported Contacts.
--
Russ Valentine
[MVP-Outlook]

When importing my Excel contacts into Outlook Contacts, all my contacts
are
sorted by last name. I want them to be sorted by Company. I tried
setting
the default for filing new contacts to Company, moving the Company
column
to
the first column in the Excel spreadsheet, and sorting the Excel
spreadsheet
by the Company. Unfortunately, I have to update six different peoples
contacts in this manner and and everyone wants them sorted by Company.
Any
suggestions?

Thank you.

 

[Guest]

Takodashouse, I had a similar problem, unless your a software expert you can
forget about it. Russ' link sends you off into the dark world of Visual Basic
& Scripting. (Custom Forms - in Outlook).

Oh Boy Russ, That was a Big Help.

Or use code to do it:
http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002

--
Russ Valentine
[MVP-Outlook]

Does this mean that I'll have to go into each individual contact and
change
the "File as" from last name to Company? Each person has over 1,000
contacts.

Thanks.

Sorting preferences do not apply to imported Contacts.
--
Russ Valentine
[MVP-Outlook]
When importing my Excel contacts into Outlook Contacts, all my contacts
are
sorted by last name. I want them to be sorted by Company. I tried
setting
the default for filing new contacts to Company, moving the Company
column
to
the first column in the Excel spreadsheet, and sorting the Excel
spreadsheet
by the Company. Unfortunately, I have to update six different peoples
contacts in this manner and and everyone wants them sorted by Company.
Any
suggestions?

Thank you.

 

[Sue Mosher [MVP-Outlook]]

You don't have to be a software expert to publish a form and run a simple script, although it's bewildering why they didn't just put the whole thing into VBA.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Takodashouse, I had a similar problem, unless your a software expert you can
forget about it. Russ' link sends you off into the dark world of Visual Basic
& Scripting. (Custom Forms - in Outlook).

Oh Boy Russ, That was a Big Help.

Or use code to do it:
http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002

--
Russ Valentine
[MVP-Outlook]

Does this mean that I'll have to go into each individual contact and
change
the "File as" from last name to Company? Each person has over 1,000
contacts.

Thanks.

:

Sorting preferences do not apply to imported Contacts.
--
Russ Valentine
[MVP-Outlook]
When importing my Excel contacts into Outlook Contacts, all my contacts
are
sorted by last name. I want them to be sorted by Company. I tried
setting
the default for filing new contacts to Company, moving the Company
column
to
the first column in the Excel spreadsheet, and sorting the Excel
spreadsheet
by the Company. Unfortunately, I have to update six different peoples
contacts in this manner and and everyone wants them sorted by Company.
Any
suggestions?

Thank you.