Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

Outlook "File as" Field customization

Hi All, I have a client that just imported quite a few clients to her Outlook client and wants to customize the "file as" field on a global setting. She is able to do this by clicking on the scroll down arrow for each client . Her goal is to have company name, last name, first name as the highlighted field on each contact. Any ideas how to customize this field to aplly to all her contacts?


Thanks!!
0
LangtechEE
Asked:
LangtechEE
  • 2
  • 2
1 Solution
 
David LeeCommented:
Hi, LangtechEE.

The code below will make the adjustment to all selected contacts.  Are you familiar with using macros?
Sub FixFileAs()
    Dim olkContact As Object
    For Each olkContact In Application.ActiveExplorer.Selection
        If olkContact.Class = olContact Then
            olkContact.FileAs = olkContact.CompanyName & ", " & olkContact.LastName & ", " & olkContact.FirstName
            olkContact.Save
        End If
    Next
    Set olkContact = Nothing
End Sub

Open in new window

0
 
LangtechEEAuthor Commented:
Thank you, will try this approach.
0
 
dladowitzCommented:
Marcia,
  Check this out. I tried it and it works.
http://support.microsoft.com/kb/291144

0
 
LangtechEEAuthor Commented:
Thank you David, this solution closes this question.
0
 
David LeeCommented:
LangtechEE,

Purely as a matter of curiosity, why choose such a complicated solution over the very simple one I offered?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now