Use Individual fields. does the street address and suite include a comma?
If so, remove it.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:




"JPorter" wrote in message
...
I have the street address (including suite number) in one column, separate
from city, state, and zip which are all in their own columns. Are you
saying
I should consolidate all of the address info into one column (address
together with state, zip, etc) or separate it as much as I can into
individual fields?

"Diane Poremsky {MVP}" wrote:

is the full address in one cell or is the street address in a cell
separate
from the city, state and zip? Try changing the street address field to
the
one outlook uses so it doesn't need mapped.

the address fields a
BusinessStreet
BusinessStreet2
BusinessStreet3
BusinessCity
BusinessState
BusinessPostalCode
BusinessCountryRegion
HomeStreet
HomeStreet2
HomeStreet3
HomeCity
HomeState
HomePostalCode
HomeCountryRegion
OtherStreet
OtherStreet2
OtherStreet3
OtherCity
OtherState
OtherPostalCode
OtherCountryRegion


--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:


Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:




"JPorter" wrote in message
...
Hi,

I am trying to import my contacts from an Excel spreadsheet into
Outlook.
I
feel like I have tried EVERYTHING! I have saved my data as both an
excel
spreadsheet and in CSV format. I have made sure the columns AND the
range
of
data is identified.

I check and check again to make sure my fields are mapped correctly. I
have
tried eliminating symbols that might interfere (even though I don't see
why
they would).

Every time I do the import, all of the data is imported EXCEPT for the
address.... it gets the name, city, state, phone etc etc but ALWAYS
leaves
out the address!

Does anyone know why this is happening and how I can fix it? If so, I
would
greatly appreciate some help.

Thanks!

JPorter