Changing "file as" for multiple contacts.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TEC - 03 Mar 2005 21:01 GMT

I exported over 13,000 contacts into excel from Outlook 2002 so that I could
clean out my database (remove duplicates ect.) and when I imported them back
into Outlook 2002 they were all "filed as" Last name, First name.

When I exported them, they were all filed as: Company, (Last, First).

They have to be filed that way again. I have about 10,000 contacts now and
there is no way I can sit here and click on each contact to change it back.
Is there a way I can change all of them at once???

I have been trying to figure this out for about 3 days and am hoping someone
on here has an answer.

Thank you in advance.

Reply to this Message

Russ Valentine [MVP-Outlook] - 03 Mar 2005 22:04 GMT

Your File As field setting will not apply to imported Contacts. Exporting
and importing is rarely a good solution for anything.
To change the File As field setting for existing Contacts will require
running code.
http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002

Signature

Russ Valentine
[MVP-Outlook]

>I exported over 13,000 contacts into excel from Outlook 2002 so that I
>could
[quoted text clipped - 14 lines]
>
> Thank you in advance.

Reply to this Message

TEC - 04 Mar 2005 16:11 GMT

Thanks Russ -

I appreciate the help a lot!

I realize now that exporting may have not been the best answer but I figured
it would be easier to clean out my database in outlook.

Thanks again!

> Your File As field setting will not apply to imported Contacts. Exporting
> and importing is rarely a good solution for anything.
[quoted text clipped - 20 lines]
> >
> > Thank you in advance.

Reply to this Message