Import problems

[Rick Campbell]

I have to change the entries in a field for several hundred records. I
export to Excel, make the changes, then import back. The problem is I have
File As set for First Name, Last Name, and when I import the records back,
they get changed to Last Name, First Name. Can anyone suggest how to get
around this?

TIA

Rick

 

[Judy Gleeson MVP - Outlook]

This is easily done in Outlook.

Change one record to the new value, group by that field, then drag all other
records you wish to change to the group.

Example: I assume you're doing this in Contacts as you mention the file as
field....

Dept of Defense needs to be changed to Department of Defence.

I change one entry of the Company field, I group by Company and drag all the
Contacts in Dept of Defense group to the Department of Defence group. Done.

Judy Gleeson - MVP Outlook
Acorn Training and Consulting
Canberra, Australia
www.acorntraining.com.au
When you post in here, always include your version, SP level, and mode (if
applicable) of Outlook - you can find this information in Help | About. Also
include the type of mail account(s) you use and any other pertinent details.
Be sure to put a concise summary of your question in the subject line, and
the full details in the body of your post.

 

[Rick Campbell]

Judy,

Thank you for your reply, but I think you misunderstood my problem. I group
on file as for merge purposes. Each file as is different: John Smith, Ray
Allen, etc.... After I import them back into Outlook, after making the
changes I need on another field, the file as field order is now Smith, John;
Allen, Ray; etc.... Which thoroughly bungles my merge.