Reality is that the "street address" component for any of the 3 address
field groups (home, business, other) is in fact stored internally by Outlook
as a single field so there is nothing you can do in terms of "separating"
the fields within the Outlook address blocks.

The Outlook import wizard simply allows you to map individual street address
fields in the import field map UI but all that happens is the various fields
are still only consolidated into a single street address line which is also
the only field that gets exported via the Outlook export wizard.

Depending on what your requirements are, you may find one of the following
links of interest:
http://www.contactgenie.com/cg20features.htm - importing
http://www.contactgenie.com/cgxfeatures.htm - exporting (can export
multi-line street addresses as separate fields)

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



"Lindy Standing" Lindy wrote in message
...
I'm having the same problem.
It seems that when addresses are input into Outlook Contacts, they cannot
be
split up into AddressStreet1, AddressStreet2 and AddresssStreet3, but all
end
up dumped in a single 'Street' box, separated by carriage returns, which
is
then exported into Excel into a single cell, called AddressStreet1,
including
those carriage returns. AddressStreets 2 and 3 remain empty, but are
there!
Separating them out can be done by importing into Word replacing each
carriage return with a symbol and then then importing back into Excel and
splitting the text into columns using the symbol as the separation point.
It's a real pain, but is possible.
Is there a way of inputting the data into the 3 AddressStreet fields
rather
than the catch all 'Street' box?
Thanks