Importing from xls to outlook merges address fields

[Bob Westfield]

Have imported my address list from xls into Outlook and Outlook has
merged three xls address fields into one 'mailing address' field.

Ideally I'd like the address fields to be kept seperate, does anyone
have any ideas?

Cheers - Bob

 

[Randy]

Pls. provide more information. What OL version, what fields?

 

[Sue Mosher [MVP-Outlook]]

If you look on the All Fields page, you should see that Outlook maintains separate street, city, state, and zip fields.

 

[Karl Timmermans]

If you're referring to 3 separate "street address" lines (whether Business,
Home, or Other) - Outlook does not maintain these as separate fields. The
Street Address is maintained as one field and if you export it, it in turn
will be exported as one field with a <CR> after each individual street
address line (which allows it to be easily used in any mail merge process).
All other address related fields are maintained separately as Sue Mosher
noted in her response.

Karl
--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com

 

[Rod]

I have the same issue, when I try to export my addresses they are
incompatible with the software my direct mail person uses to check addresses
and append zip+4 etc. I need a solution to export addresses from outlook into
seperate street address felds