 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / June 2006Importing 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. Sorting preferences do not apply to imported Contacts.  SignatureRuss Valentine [MVP-Outlook] > When importing my Excel contacts into Outlook Contacts, all my contacts > are [quoted text clipped - 10 lines] > > 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. > Sorting preferences do not apply to imported Contacts. > > When importing my Excel contacts into Outlook Contacts, all my contacts [quoted text clipped - 11 lines] > > > > Thank you. Or use code to do it: http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002 SignatureRuss Valentine [MVP-Outlook] > Does this mean that I'll have to go into each individual contact and > change [quoted text clipped - 19 lines] >> > >> > 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. > Or use code to do it: > http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002 [quoted text clipped - 22 lines] > >> > > >> > 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. SignatureSue 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 > 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 [quoted text clipped - 28 lines] >> >> > >> >> > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.