Discussion Locked

Change "File As" on existing contacts

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In Outlook 2000 I have imported 400+ contacts from a csv file. All the contacts are now last name, first name even though I set the default 'File As' in 'options|contact options' to 'Company (last name, first name)' before importing. Can I change them all to 'File As'='Company (last name, first name)' without having to go to each one individually?

7 replies

by steved

This could be done programmatically by creating an Outlook macro. I've found some documentation for Exchange 2000 indicating that the CDO library exposes a Person object for each item in the Contacts folder. One property of the object is FileAsMapping. The value you want to set it to is 5, indicating Organization, Last Name, First Name.

Sorry, I don't have any code samples for accessing and stepping through the Contacts. I realize this is more of a hint than an answer, but I hope it helps.
Steve Diamond

by johnnyextreme

I will look for code that uses this FileAsMapping property on the websites that support Outlook and Exchange like the cdolive.com and slipstick.com sites suggested by sgrit. Thanks, but I will leave this open for a while in hopes for an easier solution or a more specific answer.

by johnnyextreme

I have already done searches at these sites using the keywords "File As", "Contact", "Outlook" and others, but had no luck on this problem. I will search again using the keywords "FileAsMapping". Thanks, but I will leave this open for a while in hopes of a solution.

by steved

I found some better sources in MSDN. If you have the MSDN library, search for the article "Working with Members of an Items Collection" and the documentation on the "ContactItem Object" and its properties. (ContactItem is the right object name for working with the Outlook model, as opposed to Person when going direct to Exchange through CDO.)

If you don't have MSDN, send me your email address and I'll send you the articles. They're too long to fit here.

Steve Diamond
steved@globion.com

by johnnyextreme

Thanks Steve, no I'm not a member of the MSDN - only know a little VBA from creating an Access database. Please send the articles to j.heinzel@delco.net. Once I work out the solution I'll post it to my original question for others to use.

This discussion is closed to new replies.