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

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" wrote in message
news:88Eng.1433$Gh.151@trnddc02...
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,

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.




"Judy Gleeson MVP - Outlook" wrote in message
...
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" wrote in message
news:88Eng.1433$Gh.151@trnddc02...
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