A bug fix and a couple of refinements for Roger's macro:

Code:

Dim mapiNamespace As Outlook.NameSpace
Set mapiNamespace = Application.GetNamespace("MAPI")

Dim contactsFolder As Outlook.MAPIFolder
Set contactsFolder = mapiNamespace.GetDefaultFolder(olFolderContacts)

Dim contact As ContactItem
For Each contact In contactsFolder.Items
If contact.LastName <> "" And contact.FirstName <> "" Then
contact.FileAs = contact.LastName & ", " & contact.FirstName & " (" & contact.Email1Address & ")"
End If
Next



Edited by andy (24/08/2006 12:38)
_________________________
Remind me to change my signature to something more interesting someday