Change imported contacts to display last name first?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to change all my imported contacts (over 600) to default
filed as "last name, first name"? Would be a lot easier to find when I link
to them!
 
I don't think so. You can change it moving forward, for any new Contacts
entered, but Outlook Help (which applies to BCM as well) says to change
existing records, you have to edit each one.
I did an export to .cvs of a cut of my DB, did a couple Text-to-Columns
actions on the File As column, resorted the data to Last Name, First Name,
and I suppose one could reimport it, but no time to test this fully and no
way to guarantee success for someone else. So that's a hint, but not a full
proof method.
 
It should be possible to write a vb or sql script to update the
records.

for every record in folder
update fileas to be lastname + ", " + firstname
 
Back
Top