The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Outlook 2007; Export .CSV file KOMMA's ,,,,,,,,,,,,

    Discussion in 'Windows OS and Software' started by Ramzii, Jan 15, 2010.

  1. Ramzii

    Ramzii Notebook Evangelist

    Reputations:
    263
    Messages:
    407
    Likes Received:
    0
    Trophy Points:
    30
    When I export an .CSV file it saves itself with all of these comma's!!

    I dont get it???

    I just spent the whole day making this email datasheet backed it up as a .CSV

    So I can load it into another PC.

    When I loaded it up ALL THE EMAIL addresses were gone?!?

    When I open it up in Excel it looks like this:

    Code: 
    A.,"van Aartsen",,,,,,,,,,,,,,,,"",,,,,,,""
KinderRijk,"Haspelslaan",,,,,,,,,,,,,,,,"",,,,,,,""
Noah,"Johnson",,,,,,,,,,,,,,,,"",,,,,,,""
Mike,"C",,,,,,,,,,,,,,,,"",,,,,,,""
- Matthijs en Marline,"de la Rive Box",,,,,,,,,,,,,,,,"",,,,,,,""
Don,"Visbeen",,,,,,,,,,,,,,,,"",,,,,,,""
    The names are correctly placed and loaded but the emails have vanished?!?!

    Why? Am I doing something wrong? Shouldnt I back it up as comma seperated CSV ??

    Help me please its important

    And is there any way I can salvage the addresses from the CSV file?? :(


    Im just noticing that the company names are also gone, just like the email data.... oh this is gonna be a long night.
     
    Ramzii, Jan 15, 2010
    #1
  2. Pitabred

    Pitabred Linux geek con rat flail!

    Reputations:
    3,300
    Messages:
    7,115
    Likes Received:
    3
    Trophy Points:
    206
    What those commas mean is that the fields specified were empty. Check to see if the email addresses or something are disabled when you export them as CSV
     
    Pitabred, Jan 16, 2010
    #2
  3. surfasb

    surfasb Titles Shmm-itles

    Reputations:
    2,637
    Messages:
    6,370
    Likes Received:
    0
    Trophy Points:
    205
    Ah, gotta love life.
     
    surfasb, Jan 16, 2010
    #3
  4. tSNOOK12

    tSNOOK12 Newbie

    Reputations:
    0
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    5
    where were you planning to export the file?
    meaning what program did you plan to read the .csv file?
     
    tSNOOK12, Jan 16, 2010
    #4
  5. flipfire

    flipfire Moderately Boss

    Reputations:
    6,156
    Messages:
    11,214
    Likes Received:
    68
    Trophy Points:
    466
    Have you tried importing it back into Outlook? It might show up again.
     
    flipfire, Jan 16, 2010
    #5
  6. Ramzii

    Ramzii Notebook Evangelist

    Reputations:
    263
    Messages:
    407
    Likes Received:
    0
    Trophy Points:
    30
    parapapapaaa, I'm living it. :eek:

    Outlook 2007, on the other pc.

    Yes, on the other pc, same story.


    Im halfway through the process of manually doing shizzlemenizzle.

    I hate Outlook and its CSV's
     
    Ramzii, Jan 16, 2010
    #6