Batch change contact "file as" field in Outlook 2007

[Netorius77]

Can anyone provide a method to batch change all my existing contacts (687) in
Outlook 2007. I would like to change the "File as" field from "First Last" to
"Last, First".

I can change each individua entry manually in the "File as" field in the
address card view, but that is pretty labourius.

I tried to export all into a CSV file and then manually manipulate the "File
as" field in Excel, but the field is not exported, so that didn't help.

 

[Diane Poremsky [MVP]]

See http://www.slipstick.com/contacts/fileas.asp

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205

 

[Netorius77]

Works perfectly - well explained in the text as well. Thanks Diane.

See http://www.slipstick.com/contacts/fileas.asp

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205

Can anyone provide a method to batch change all my existing contacts (687)
in
Outlook 2007. I would like to change the "File as" field from "First Last"
to
"Last, First".

I can change each individua entry manually in the "File as" field in the
address card view, but that is pretty labourius.

I tried to export all into a CSV file and then manually manipulate the
"File
as" field in Excel, but the field is not exported, so that didn't help.