Solved

Outlook 2007 contacts, file as company name

Posted on 2010-11-15
4
630 Views
Last Modified: 2012-05-10
I've got a client that uses Outlook 2007.  The have approximately 1000 contacts and currently have them filed by Last Name, First Name using the business card view.  They would like to change all their contacts to have them filed by company name instead of Last Name, First Name.  I see how I can do that for new contacts, but I don't see how I can change the existing contacts to be filed like that.  Any help would be appreciated.  Thanks.
0
Comment
Question by:SupermanTB
  • 2
4 Comments
 
LVL 15

Expert Comment

by:JBond2010
ID: 34139411
Work around!

Change the company of one of your contacts to '1' or '1111' or a number like that.

Now group by Company Name, and drag all your 'None' Contacts from both groups into teh new group so that the all get Company Name 1.

Now delete the Company Name from one contact, and drag them all back again. They should all now be in the same group
0
 

Author Comment

by:SupermanTB
ID: 34139480
I don't think that will accomplish the task of filing them by their company name.  I do understand that your instructions will accomplish putting all of those contacts in the same group, but that's not what I'm trying to do here.  The client likes to look people up and have them sorted according to their company name.  Which is the reason for filing them that way.
0
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 34139633
The code I used at http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_23358371.html#a21453213 should work here as well.  Just change:

                .FileAs = .LastName & ", " & .FirstName

to:

                .FileAs = .CompanyName & ": " & .LastName & ", " & .FirstName

or whatever.  The example above produces:

ACME Industries: Coyote, Wily
0
 

Author Closing Comment

by:SupermanTB
ID: 34139830
Awesome, I didn't know you could do that w/ Outlook.  
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You may have a outside contractor who comes in once a week or seasonal to do some work in your office but you only want to give him access to the programs and files he needs and keep privet all other documents and programs, can you do this on a loca…
Find out what you should include to make the best professional email signature for your organization.
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question