?
Solved

Outlook 2007 contacts, file as company name

Posted on 2010-11-15
4
Medium Priority
?
638 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 93

Accepted Solution

by:
Patrick Matthews earned 2000 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

777 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