Solved

Outlook 2007 contacts, file as company name

Posted on 2010-11-15
4
629 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now