Importing Outlook contacts to Access - Square for address break

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve Maiorano - 04 Oct 2004 23:03 GMT

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.

Reply to this Message

Sue Mosher [MVP-Outlook] - 05 Oct 2004 04:11 GMT

I believe it's a line feed -- Chr(10) -- or carriage return -- Chr(13).

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> There are several contacts in my company's public folders
> in Outlook that have two lines for the address instead of
[quoted text clipped - 5 lines]
> How can I get rid of this square? I am using Office 2003.
> Thanks.

Reply to this Message

Rate this thread: