Exzporting Contacts and Pasting Contacts Into Excel

[srm]

I'm using Outook XP. Does anyone know if Microsoft plans to fix the
following export issue:

When you export Microsoft Outlook Contacts in either comma or tab
delimited format, any street addresses that contain more than one line
are exported with carriage returns separating the multiple lines. This
results in a skewed output file containing multiple records for those
contacts containing multi-line street addresses.

This is also true if you copy and paste records from Outlook into
Excel except with a different result. I used the Busienss Address
field in my view. When pasted into Excel, the first line of the
addres is in the correct cell but the next two lines are on separate
rows. For example,

Title, Full Name, Title, Company, Address line 1
Address line 2
Address line 3
<next record>

The address lines represent the street, city, state, etc. The data is
not pasted correctly.

 

[Rob Schneider]

Is your question/issue when Microsoft will fix something, or do you want
help working an issue?

In case you wish to work the issue:

I tried exporting to CSV file from Outlook 2003 to .CSV and I don't see
this problem.

I also exported directo XLS format from Outlook 2003, and don't see this
problem.

So .. maybe it was fixed in 2003? Or something else is going on.

Hope this is useful to you. Let us know.

rms

 

[Karl Timmermans]

Not sure what or why you think there is a problem. It is being exported
properly to enable a "multi-line" field to be displayed and used as a
multi-line field otherwise you have one single continuous line. Without
those intra-field line breaks - how would any program know where line 1 ends
and line 2 starts?

If your question is (and your reqmt is) - do addresses get exported to
multiple address lines - answer is no. Not a bug or a problem - it's just
the way the program operates and any program using this exported data should
be able to properly display the street address when only using one address
line.

I suspect you are referring to a single address being displayed on multiple
lines within one address line cell (normal) and not in separate rows. If it
was actually displayed on "separate rows" - all your fields would have been
skewed.

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

 

[srm]

Thank you for your help. Lets say I have an address such as

123 Third Street
Suite A

In Outlook there is a Business Street, Business Street 2 and Business
Street 3 when you export. Unless I'm mis-understanding how it works,
I would assume "123 Third Street" would go with Business Street 1 and
"Suite A" would go with Business Street 2. So when I export to a CSV
file and then open it in Excel, "123 Third Street" would be under the
Business Street column and "Suite A" would be under the Business
Street 2 column. They would both be on the same row (for the same
contact) but under the appropriate column.

Currently, both "123 Third Street" and "Suite A" are in the same cell
with a carriage return separating them. The [] represents a carraige
return.

123 Third Street[]
Suite A

Business Street 2 and Business Street 3 never have data in those cells
for each contact. Like I said, maybe it just wasn't designed to work
this way but then why are there Business Street 2 and Business Street
3 fields?

Thank you.

srm

 

[srm]

Thank you. Lets say I have a folder with contacts. One of the items
I have listed is Business Address. If I copy the contacts (select the
rows) and paste them into Excel, the Busiess address is listed as
follows:

One the first row of the contact the first line of the address is
list. Then it goes to row 2, lists the second line of the address and
then row to list the third line of the address. Both of these items
are in the first column. It then continues the rest of the fields in
row three. Basically for each contact I have three rows of data.

Maybe I'm missing something or doing something incorrect.

srm

 

[Karl Timmermans]

I agree that I don't understand why the multiple address lines appear on the
export screen - since they have no use anymore. My best guess would be that
it's a hangover from some early version of Outlook and tehse fields have not
been taken out since it was first introduced (or maybe these should never
have been in the Outlook export field display - no idea). The Bstreet2 & 3
fields are allow you to import 3 line addresses from your input data source
if that's how your input file is structured (i.e. - Outlook allows 3 and we
allow 4 separate lines but with the same affect).

The complete street address is contained in the first address line and has
been since Outlook '2000 at least. The fact is tho you can have as many line
breaks in your Business Street address as you want when you create it
manually. While admittedly displaying and including these fields in the
export file is confusing - that unfortuantely this is the way the Outlook
Export process works (we don't bother showing the extraneous address street
field labels in our export process since there would be no way to know for
sure how many total address lines would be required without first reading
every contact record that is being exported which would make it an
unbearably slow process for everyone to service a few).

At the same time having all street address info in one field makes things
much easier when doing a mail merge etc since there is no need to worry
about having to compress the address for blank lines so from that sense -
the way it is exported makes a whole lot of sense.

Karl

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

Thank you for your help. Lets say I have an address such as

123 Third Street
Suite A

In Outlook there is a Business Street, Business Street 2 and Business
Street 3 when you export. Unless I'm mis-understanding how it works,
I would assume "123 Third Street" would go with Business Street 1 and
"Suite A" would go with Business Street 2. So when I export to a CSV
file and then open it in Excel, "123 Third Street" would be under the
Business Street column and "Suite A" would be under the Business
Street 2 column. They would both be on the same row (for the same
contact) but under the appropriate column.

Currently, both "123 Third Street" and "Suite A" are in the same cell
with a carriage return separating them. The [] represents a carraige
return.

123 Third Street[]
Suite A

Business Street 2 and Business Street 3 never have data in those cells
for each contact. Like I said, maybe it just wasn't designed to work
this way but then why are there Business Street 2 and Business Street
3 fields?

Thank you.

srm

"Karl Timmermans" <[email protected]> wrote in message

Not sure what or why you think there is a problem. It is being exported
properly to enable a "multi-line" field to be displayed and used as a
multi-line field otherwise you have one single continuous line. Without
those intra-field line breaks - how would any program know where line 1 ends
and line 2 starts?

If your question is (and your reqmt is) - do addresses get exported to
multiple address lines - answer is no. Not a bug or a problem - it's just
the way the program operates and any program using this exported data should
be able to properly display the street address when only using one address
line.

I suspect you are referring to a single address being displayed on multiple
lines within one address line cell (normal) and not in separate rows. If it
was actually displayed on "separate rows" - all your fields would have been
skewed.

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

 

[Sue Mosher [MVP-Outlook]]

Outlook has never used those fields for multi-line addresses, to my
knowledge, or at least has never automatically populated them with the data
the user enters in the multi-line address entry control on the contact form.

 

[srm]

Karl:

Thank you

srm

I agree that I don't understand why the multiple address lines appear on the
export screen - since they have no use anymore. My best guess would be that
it's a hangover from some early version of Outlook and tehse fields have not
been taken out since it was first introduced (or maybe these should never
have been in the Outlook export field display - no idea). The Bstreet2 & 3
fields are allow you to import 3 line addresses from your input data source
if that's how your input file is structured (i.e. - Outlook allows 3 and we
allow 4 separate lines but with the same affect).

The complete street address is contained in the first address line and has
been since Outlook '2000 at least. The fact is tho you can have as many line
breaks in your Business Street address as you want when you create it
manually. While admittedly displaying and including these fields in the
export file is confusing - that unfortuantely this is the way the Outlook
Export process works (we don't bother showing the extraneous address street
field labels in our export process since there would be no way to know for
sure how many total address lines would be required without first reading
every contact record that is being exported which would make it an
unbearably slow process for everyone to service a few).

At the same time having all street address info in one field makes things
much easier when doing a mail merge etc since there is no need to worry
about having to compress the address for blank lines so from that sense -
the way it is exported makes a whole lot of sense.

Karl

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

Thank you for your help. Lets say I have an address such as

123 Third Street
Suite A

In Outlook there is a Business Street, Business Street 2 and Business
Street 3 when you export. Unless I'm mis-understanding how it works,
I would assume "123 Third Street" would go with Business Street 1 and
"Suite A" would go with Business Street 2. So when I export to a CSV
file and then open it in Excel, "123 Third Street" would be under the
Business Street column and "Suite A" would be under the Business
Street 2 column. They would both be on the same row (for the same
contact) but under the appropriate column.

Currently, both "123 Third Street" and "Suite A" are in the same cell
with a carriage return separating them. The [] represents a carraige
return.

123 Third Street[]
Suite A

Business Street 2 and Business Street 3 never have data in those cells
for each contact. Like I said, maybe it just wasn't designed to work
this way but then why are there Business Street 2 and Business Street
3 fields?

Thank you.

srm

"Karl Timmermans" <[email protected]> wrote in message

Not sure what or why you think there is a problem. It is being exported
properly to enable a "multi-line" field to be displayed and used as a
multi-line field otherwise you have one single continuous line. Without
those intra-field line breaks - how would any program know where line 1 ends
and line 2 starts?

If your question is (and your reqmt is) - do addresses get exported to
multiple address lines - answer is no. Not a bug or a problem - it's just
the way the program operates and any program using this exported data should
be able to properly display the street address when only using one address
line.

I suspect you are referring to a single address being displayed on multiple
lines within one address line cell (normal) and not in separate rows. If it
was actually displayed on "separate rows" - all your fields would have been
skewed.

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


I'm using Outook XP. Does anyone know if Microsoft plans to fix the
following export issue:

When you export Microsoft Outlook Contacts in either comma or tab
delimited format, any street addresses that contain more than one line
are exported with carriage returns separating the multiple lines. This
results in a skewed output file containing multiple records for those
contacts containing multi-line street addresses.

This is also true if you copy and paste records from Outlook into
Excel except with a different result. I used the Busienss Address
field in my view. When pasted into Excel, the first line of the
addres is in the correct cell but the next two lines are on separate
rows. For example,

Title, Full Name, Title, Company, Address line 1
Address line 2
Address line 3
<next record>

The address lines represent the street, city, state, etc. The data is
not pasted correctly.

 

[Coby King]

So, is there a work around for the following problem.

My OL2K contacts files have numerous records with
multiple address lines. I need to export to Excel so an
outside vendor can use the addresses. As you know,
during the OL2K to Excel 2K process, the multiple lines
get converted to one line, despite the fact that the
export engine appears to anticipate the use of up to
three lines (i.e., Street 2, Street 3). Because the
first line of these multi-line addresses is often a
building name, leaving it all on one line is not
acceptable to me or the Postal Service.

Is there a way to get OL to export to Excel so that the
extra lines get dropped into separate Excel fields?

Thanks.

 

[Karl Timmermans]

The reality is that the address lines, while they "appear" as one line in a
normal worksheet layout (I suspect you have your rows set to show only only
one line) - this column actually has line breaks embedded in between the
lines (which are not visible on screen). If you increase the size of your
cell horizontally and vertically - you'll see the address lines show up
correctly. You can have any number of lines contained in the address - not
just 3 lines.

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