Let me put it another way: The problem is that Outlook doesn't really have any BusinessStreet2 and BusinessStreet3 fields. I don't know why the Import/Export Wizard teases users with the suggestion that it does. But I've never seen it break Business Street into multiple fields in an export.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Jemmeroni" wrote in message ...
Because Outlook nests fields BusinessStreet2 and BusinessStreet3 in
BusinessStreet, I assumed that when it exported data, it would separate the
fields as default: how do I achieve this behavior, then?

"Sue Mosher [MVP-Outlook]" wrote:

That's expected behavior, since Outlook has only a single BusinessAddressStreet property that stores the street address. What behavior are you looking for?

"Jemmeroni" wrote in message ...
When I export to either an Excel or .CSV file, data from BusinessStreet;
BusinessStreet2; BusinessStreet3 fields are mapped to BusinessStreet only,
with no spaces, leaving the other two fields empty.

I have used the Clear Map and Default Map commands to clear any old mapping.

Any suggestions?