Exporting Contacts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I export my contacts to an Excel file or "comma separated value" (csv)
file, I get small "boxes" at the end of each entry in the address fields.
Does anyone know why and/or how to get rid of them?
 
Stuart I am having the same problem. I even exported to excel and access.
In outlook when you put in an address sample 123 X Street, you hit enter to
go to the next line. When you try to setup your labels it puts a l symbol.
I have tryed to deliminate this but still can't get it to work. It also
duplicates every label. Did you get any help from anyone?

Thank you.
 
Street address lines are exported as a single field. The box you see is
actually the <CR> chr$(13) character if memory serves me correctly. Each
line within the address ends with <CR> <LF> chr$(13) chr$(10). The only
reason you'd need to get rid of them is if you needed to explicitly handle
each line separately. If you're doing a standard mail-merge for example -
these lines would print out correctly if you set the street address to this
single field without any blank lines between street and city/state (again as
an example)

In effect - Outlook exports "multi-line" fields within a single
line/record/row which the other programs handle.

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
 
Thanks for the info Karl, but that doesn't solve my problem. I am trying to
create mailing lists for a 3rd party who wants an Excel .csv file with each
address line separately catagorized. These "characters" [<CR> chr$(13) ]
cannot be removed and they print! I tried to copy them and then use the
find/replace tool to get rid of them, but Excel does not "see" them for this
action -yet it prints them (??!!). Any thoughts about how to get rid of them?
 
Unfortunately my forte is not with Excel in terms of what you can and can't
do when it comes to embedded "End-of-line" characters and splitting the
fields based on those delimiters. If there isn't a way to accomplish the
"Split text" function within Excel, then the only other "simple" way to do
that is to write some custom code to split the lines within the Street
address column into mltiple cells.

The E-O-L characters unfortunately would be printed by any service which
does not recognize them. There are likely just as many services that do
support this multi-line format for printing addresses as there are those who
require the street lines to be explicitly separated.

We are going to be releasing a solution that addresses this and a litnany of
other things but not sure yet what the exact release date will be so
unfortunately can't offer a solution to service your immediate requirements
at this point in time.

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


Stuart said:
Thanks for the info Karl, but that doesn't solve my problem. I am trying
to
create mailing lists for a 3rd party who wants an Excel .csv file with
each
address line separately catagorized. These "characters" [<CR> chr$(13) ]
cannot be removed and they print! I tried to copy them and then use the
find/replace tool to get rid of them, but Excel does not "see" them for
this
action -yet it prints them (??!!). Any thoughts about how to get rid of
them?

Karl Timmermans said:
Street address lines are exported as a single field. The box you see is
actually the <CR> chr$(13) character if memory serves me correctly. Each
line within the address ends with <CR> <LF> chr$(13) chr$(10). The only
reason you'd need to get rid of them is if you needed to explicitly
handle
each line separately. If you're doing a standard mail-merge for example -
these lines would print out correctly if you set the street address to
this
single field without any blank lines between street and city/state (again
as
an example)

In effect - Outlook exports "multi-line" fields within a single
line/record/row which the other programs handle.

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
Click to expand...
Click to expand...
 
Ok, thanks for the reply.

Karl Timmermans said:
Unfortunately my forte is not with Excel in terms of what you can and can't
do when it comes to embedded "End-of-line" characters and splitting the
fields based on those delimiters. If there isn't a way to accomplish the
"Split text" function within Excel, then the only other "simple" way to do
that is to write some custom code to split the lines within the Street
address column into mltiple cells.

The E-O-L characters unfortunately would be printed by any service which
does not recognize them. There are likely just as many services that do
support this multi-line format for printing addresses as there are those who
require the street lines to be explicitly separated.

We are going to be releasing a solution that addresses this and a litnany of
other things but not sure yet what the exact release date will be so
unfortunately can't offer a solution to service your immediate requirements
at this point in time.

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


Stuart said:
Thanks for the info Karl, but that doesn't solve my problem. I am trying
to
create mailing lists for a 3rd party who wants an Excel .csv file with
each
address line separately catagorized. These "characters" [<CR> chr$(13) ]
cannot be removed and they print! I tried to copy them and then use the
find/replace tool to get rid of them, but Excel does not "see" them for
this
action -yet it prints them (??!!). Any thoughts about how to get rid of
them?

Karl Timmermans said:
Street address lines are exported as a single field. The box you see is
actually the <CR> chr$(13) character if memory serves me correctly. Each
line within the address ends with <CR> <LF> chr$(13) chr$(10). The only
reason you'd need to get rid of them is if you needed to explicitly
handle
each line separately. If you're doing a standard mail-merge for example -
these lines would print out correctly if you set the street address to
this
single field without any blank lines between street and city/state (again
as
an example)

In effect - Outlook exports "multi-line" fields within a single
line/record/row which the other programs handle.

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



When I export my contacts to an Excel file or "comma separated value"
(csv)
file, I get small "boxes" at the end of each entry in the address
fields.
Does anyone know why and/or how to get rid of them?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top