Importing Outlook contacts to Access - Square for address break

  • Thread starter Thread starter Steve Maiorano
  • Start date Start date
S

Steve Maiorano

There are several contacts in my company's public folders
in Outlook that have two lines for the address instead of
one. When I export contacts from Outlook to Access for a
mailing list, that hard return appears in the address
column in Access as a square. I would like to get rid of
this square in Access or in Ecxel for a cleaner list, but
I can't find the symbol anywhere to search and replace it.
How can I get rid of this square? I am using Office 2003.
Thanks.
 
I believe it's a line feed -- Chr(10) -- or carriage return -- Chr(13).
 
Back
Top