"file as" field from Excel import into Contacts

[MMangen]

I have figured out (thanks to this wonderful community) how to import
contacts from an Excel sheet into Outlook....one tiny problem though....how
do I change (for all the imported contacts) how they are filed as.

I do not see the field "file as" as a mapping option when doing the import.

Thanks in advance for any light you can shed on this matter.

 

[Russ Valentine [MVP-Outlook]]

You cannot control what happens to the File As field when you import data.
You can change it after the fact if you want to run code:
http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002

 

[MMangen]

Russ - thank you --- how do I run that code?

You cannot control what happens to the File As field when you import data.
You can change it after the fact if you want to run code:
http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002
--
Russ Valentine
[MVP-Outlook]

I have figured out (thanks to this wonderful community) how to import
contacts from an Excel sheet into Outlook....one tiny problem
though....how
do I change (for all the imported contacts) how they are filed as.

I do not see the field "file as" as a mapping option when doing the
import.

Thanks in advance for any light you can shed on this matter.

 

[Russ Valentine [MVP-Outlook]]

I included a link that tells you how to do it.
--
Russ Valentine
[MVP-Outlook]

Russ - thank you --- how do I run that code?

You cannot control what happens to the File As field when you import
data.
You can change it after the fact if you want to run code:
http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002
--
Russ Valentine
[MVP-Outlook]

I have figured out (thanks to this wonderful community) how to import
contacts from an Excel sheet into Outlook....one tiny problem
though....how
do I change (for all the imported contacts) how they are filed as.

I do not see the field "file as" as a mapping option when doing the
import.

Thanks in advance for any light you can shed on this matter.