1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Outlook contacts export

Discussion in 'Microsoft Mail (Outlook / OE / Windows Mail)' started by ramon82, 2008/10/09.

  1. 2008/10/09
    ramon82

    ramon82 Inactive Thread Starter

    Joined:
    2008/08/07
    Messages:
    66
    Likes Received:
    0
    Outlook contacts export

    Hi all

    I would like to know if there is any application allowing you to export the contact details of outlook to an Excel file?

    Thanks!
     
    ramon82,
    #1
  2. 2008/10/09
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    12,315
    Likes Received:
    252
    Click on File->Export and away you go...
     
    Steve R Jones,
    #2


  3. to hide this advert.

  4. 2008/10/09
    ramon82

    ramon82 Inactive Thread Starter

    Joined:
    2008/08/07
    Messages:
    66
    Likes Received:
    0
    Ok using FILE>IMPORT/EXPORT from outlook works.

    I now noticed that the ADDRESS field is not distributed in one line but on multiple lines in one cell. In fact now a letter in the form of a square is being printed to indicate that there is a multiple line entry. See http://img392.imageshack.us/img392/8264/newpicture222ol3.jpg for more detail.

    Any idea how can I get rid of this?? cannot make it manually as addresses amount to over 3000 and I need to print them in a mail merge!!

    Many Thanks
     
    ramon82,
    #3
  5. 2008/10/09
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    12,315
    Likes Received:
    252
    You could play around with exporting to Comma Separated Values...or Access if you're familar with it.

    Could also Google the heck out of exporting and see if there's any software to export for you.
     
    Steve R Jones,
    #4
  6. 2008/10/13
    ramon82

    ramon82 Inactive Thread Starter

    Joined:
    2008/08/07
    Messages:
    66
    Likes Received:
    0
    Problem solved. Exported from outlook to a CSV file and then created a DOC file with a mail merge. Data exported and printed successfully. Thanks for all your help :)
     
    ramon82,
    #5

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...