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.

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

--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:dailytips-subscribe-(E-Mail Removed)

EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)

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

"Netorius77" <(E-Mail Removed)> wrote in message
news:CA323902-E8E7-4715-B5FA-(E-Mail Removed)...
> 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.

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

"Diane Poremsky [MVP]" wrote:

> See http://www.slipstick.com/contacts/fileas.asp
>
> --
> Diane Poremsky [MVP - Outlook]
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com/
>
> Outlook Tips by email:
> mailto:dailytips-subscribe-(E-Mail Removed)
>
> EMO - a weekly newsletter about Outlook and Exchange:
> mailto:EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>
> Do you keep Outlook open 24/7? Vote in our poll:
> http://forums.slipstick.com/showthread.php?t=22205
>
> "Netorius77" <(E-Mail Removed)> wrote in message
> news:CA323902-E8E7-4715-B5FA-(E-Mail Removed)...
> > 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.
>