Link to home
Start Free TrialLog in
Avatar of LangtechEE
LangtechEE

asked on

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!!
Avatar of David Lee
David Lee
Flag of United States of America image

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

Avatar of LangtechEE
LangtechEE

ASKER

Thank you, will try this approach.
ASKER CERTIFIED SOLUTION
Avatar of dladowitz
dladowitz

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you David, this solution closes this question.
LangtechEE,

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