|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
June 15th 06, 10:51 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
Importing Excel to sort as Company
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. 
|
| Ads |
|
#2
June 16th 06, 02:50 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Importing Excel to sort as Company
Sorting preferences do not apply to imported Contacts.
-- Russ Valentine [MVP-Outlook] "Takodashouse" wrote in message ... 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.
|
|
#3
June 16th 06, 05:15 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Importing Excel to sort as Company
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 [MVP-Outlook]" wrote: Sorting preferences do not apply to imported Contacts. -- Russ Valentine [MVP-Outlook] "Takodashouse" wrote in message ... 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.
|
|
#4
June 16th 06, 10:14 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Importing Excel to sort as Company
Or use code to do it:
http://support.microsoft.com/default...Product=ol2002 -- Russ Valentine [MVP-Outlook] "Takodashouse" wrote in message ... 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 [MVP-Outlook]" wrote: Sorting preferences do not apply to imported Contacts. -- Russ Valentine [MVP-Outlook] "Takodashouse" wrote in message ... 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.
|
|
#5
June 18th 06, 12:55 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Importing Excel to sort as Company
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 [MVP-Outlook]" wrote: Or use code to do it: http://support.microsoft.com/default...Product=ol2002 -- Russ Valentine [MVP-Outlook] "Takodashouse" wrote in message ... 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 [MVP-Outlook]" wrote: Sorting preferences do not apply to imported Contacts. -- Russ Valentine [MVP-Outlook] "Takodashouse" wrote in message ... 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.
|
|
#6
June 18th 06, 01:18 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
Importing Excel to sort as Company
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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "SAlders" wrote in message ... 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 [MVP-Outlook]" wrote: Or use code to do it: http://support.microsoft.com/default...Product=ol2002 -- Russ Valentine [MVP-Outlook] "Takodashouse" wrote in message ... 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 [MVP-Outlook]" wrote: Sorting preferences do not apply to imported Contacts. -- Russ Valentine [MVP-Outlook] "Takodashouse" wrote in message ... 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.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Importing From Excel | D. Jarrett | Outlook - Using Contacts | 6 | February 12th 08 07:10 PM |
| trouble importing excel to calendar | fandrews671 | Outlook - Calandaring | 1 | April 5th 06 10:03 AM |
| Importing contacts from Excel | Joe Soap | Outlook - Using Contacts | 1 | February 23rd 06 05:55 PM |
| HELP HELP - Importing Contacts from Excel List | TotallyConfused | Outlook - Using Contacts | 9 | February 20th 06 07:10 PM |
| Can you merge an excel file of a company directory to contacts? | ERik Blumenfeld | Outlook - Using Contacts | 1 | January 9th 06 12:46 AM |
Linear Mode
