Importing Excel to sort as Company

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Russ Valentine said:
Sorting preferences do not apply to imported Contacts.
--
Russ Valentine
[MVP-Outlook]
Takodashouse said:
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.
 
Or use code to do it:
http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002

--
Russ Valentine
[MVP-Outlook]
Takodashouse said:
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.

Russ Valentine said:
Sorting preferences do not apply to imported Contacts.
--
Russ Valentine
[MVP-Outlook]
Takodashouse said:
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.
 
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.

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

--
Russ Valentine
[MVP-Outlook]
Takodashouse said:
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.

Russ Valentine said:
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.
 
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


SAlders said:
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.

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

--
Russ Valentine
[MVP-Outlook]
Takodashouse said:
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.
 
Back
Top