Outlook driving me mad!

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

Diane
Fri May 02 09:20:12 PDT 2008

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 are:
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:
dailytips-subscribe-request@lists.outlooktips.net

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM



"JPorter" <JPorter@discussions.microsoft.com> wrote in message
news:95CA0E3A-1A7E-44C7-AFFF-BFB6D821F667@microsoft.com...
> 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

JPorter
Fri May 02 09:29:01 PDT 2008

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 are:
> 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:
> dailytips-subscribe-request@lists.outlooktips.net
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
> Subscribe to Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>
>
>
> "JPorter" <JPorter@discussions.microsoft.com> wrote in message
> news:95CA0E3A-1A7E-44C7-AFFF-BFB6D821F667@microsoft.com...
> > 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
>

Diane
Fri May 02 09:58:42 PDT 2008

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:
dailytips-subscribe-request@lists.outlooktips.net

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM



"JPorter" <JPorter@discussions.microsoft.com> wrote in message
news:A40BA06B-BB90-4D36-908A-ADDACE2981E8@microsoft.com...
> 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 are:
>> 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:
>> dailytips-subscribe-request@lists.outlooktips.net
>>
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>> Subscribe to Exchange Messaging Outlook newsletter:
>> EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>>
>>
>>
>> "JPorter" <JPorter@discussions.microsoft.com> wrote in message
>> news:95CA0E3A-1A7E-44C7-AFFF-BFB6D821F667@microsoft.com...
>> > 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
>>

Lindy
Tue May 27 07:28:03 PDT 2008

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

Karl
Tue May 27 09:36:45 PDT 2008

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 - re: importing
http://www.contactgenie.com/cgxfeatures.htm - re: 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 Standing@discussions.microsoft.com> wrote in message
news:E480ED51-206A-48D3-BCB4-C0D0F6EF0871@microsoft.com...
> 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