No. I would never run those steps. Exporting and importing Outlook data
always loses and/or mangles data. I try never to do so.
The question I was asking was what sort order you had set for your Outlook
Address Book.
Here's my best guess, without having all the information: Whenever you
import data into Outlook, your File As... field will be set incorrectly and
will not obey the preferences you set for it. So if your Outlook Address
Book is set to sort by the File As... field, it will be sorted incorrectly.
You may need to run some code to reset those File As... fields:
http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002

Signature
Russ Valentine
[MVP-Outlook]
> Thanks Russ for your patience...
>
[quoted text clipped - 43 lines]
>> >
>> > Best,
I appreciate your help. I'll just create a work around.
I like exporting Outlook Contacts to Excel because you can see all the
fields at once and can use the Excel file to more easily create complex
custom mail merges. I also find that mail merges with Excel files work more
predictably than merges with Outlook Contacts.
As mentioned, the address book sort is correct. No problems with the "File
As" in this case. The problem is when adding an address via "To" to a new
message. It seems that Outlook is "concatenating" Address Book fields
"Title," " First Name" and "Last Name" into the "Name" column (field)
displayed.
Wouldn't you agree, it's frustrationg. I mean if Microsoft can't get the
import/export functionality right, why include it? When I re-import the
Excel to Outlook, I am careful to ensure that all fields are mapped corectly.
That's all that should be required. Why should it require more than that?
I know programming is complex and testing software under real world
conditions is even harder. But, Outlook performed as I described, and it's
repeataqble, as described. You may not want too try the procedures yourself,
because you know import/export is quirky but someone on the Outlook
development team should. All programers must ensure that the functionality
they provide performs according to design and more importanly is in-line with
the users mental model. (Heck, the team can contact me, I be happy to
participate in their user experience/ interaction design tests.)
Stay well,
> No. I would never run those steps. Exporting and importing Outlook data
> always loses and/or mangles data. I try never to do so.
[quoted text clipped - 53 lines]
> >> >
> >> > Best,
Russ Valentine [MVP-Outlook] - 03 May 2006 20:47 GMT
Yes, it's frustrating.
I'm not sure I understand what's going on in your case.
You never did specify by which fields you are sorting the Outlook Address
Book.
The Full Name field is never used for sorting the Outlook Address Book. The
File As... field is
Importing has always been full of unpleasant surprises in Outlook.

Signature
Russ Valentine
[MVP-Outlook]
>I appreciate your help. I'll just create a work around.
>
[quoted text clipped - 98 lines]
>> >> >
>> >> > Best,