Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Portland, Maine, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export to Excel (Outlook 2000/XP)

    I know that the import/export feature of Outlook has the limitations of not being able to do custom fields and can not be used for a public folder. I am exporting names/addresses to an Excel file so I can send the file to a printing company. The problem is with 2 line addresses. Even if I choose Business Street and Business Street2, all lines of a multi line address are in the Business Street field. When opened in Excel, where there should be a return in the street address, there is a symbol that looks like a small box. When printed, this box prints. I can not do a search/replace on the character.

    Is anyone else having this problem? Besides programming the export, does anyone have a solution?

  2. #2
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export to Excel (Outlook 2000/XP)

    The funny character could be a line feed + return. I don't think you can search for the vbcr constant. You can search for chr(13) & chr(10) which is the linefeed + return code.

  3. #3
    Lounger
    Join Date
    Apr 2002
    Location
    North Bergen, New Jersey, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export to Excel (Outlook 2000/XP)

    Kind of a work-around ... open up a Word Document, then use the find/replace feature for special characters to locate the one that matches. Then copy from the Word Find, to the Excel Find and that should do it.

    Maybe ... <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •