Export email addresses from Word to Windows Live Mail


  1. Posts : 4
    Windows 7 64 bit
       #1

    Export email addresses from Word to Windows Live Mail


    I am sorry if this question has been posted elsewhere in the Forum, but I have not been able to find anything that relates. I am trying to export a list of email addresses from a Word document into Windows Live Mail. I have tried to cut and paste, but it just doesn't work. Has anyone any idea how I can achieve this? Thanks for your help.
      My Computer


  2. Posts : 53,363
    Windows 10 Home x64
       #2

    Welcome again to Seven Forums Wembley You'd want to see if you can convert the file into a .csv file that you can then import into WLM. See if these instructions allow you to create a .csv file

    How to Change a Word File to a Comma Delimited File

    Then use these instructions to import the .csv file

    To import offline contacts into Windows Live Mail

    Open Windows Live Mail by clicking the Start button . In the search box, type Mail, and then, in the list of results, click Windows Live Mail.

    Export email addresses from Word to Windows Live Mail-9fbf8917-861e-4b62-b836-3a0217fbd982_17.jpg

    In the lower-left corner, select Contacts.


    Click Import on the ribbon.


    Select the file format that matches your exported contacts (.csv or .vcf).


    Click Browse and then select the folder containing your exported contacts.


    Click Next and select the check boxes next to the fields that you want to import.


    Click Finish.

    How do I import and export email, contacts, and calendars with Windows Live Mail? - Windows Help

    A Guy
      My Computer


  3. Posts : 4
    Windows 7 64 bit
    Thread Starter
       #3

    Hi A Guy, I have done all the things suggested, and all that has happened is that I now have dozens of duplications in my contact list and no sign of the distribution list I was trying to import Do you have any suggestions as to how I can sort this mess out??!!!
      My Computer


  4. Posts : 53,363
    Windows 10 Home x64
       #4

    Oh boy, it sounds like you weren't just trying to import some addresses, you were trying to import a list of addresses to stay as a list? I'll post for some experts, I'm not much use during the week. Hang in there.

    A Guy
      My Computer


  5. Posts : 4,161
    Windows 7 Pro-x64
       #5

    Wembley said:
    Hi A Guy, I have done all the things suggested, and all that has happened is that I now have dozens of duplications in my contact list and no sign of the distribution list I was trying to import Do you have any suggestions as to how I can sort this mess out??!!!
    I'm confused. Why were you importing contacts that already existed?

    Are you trying to create a list of contacts from "All Contacts" that are in this distribution list?

    If so, all you need to do is create a new category. Name it "Distribution" or something meaningful to you. Click on All Contacts then in the list of contacts, select the ones you want and drag them to the Distribution category in the left pane. It's just like moving files. Contacts will still show in All Contacts but the ones you have selected will now appear when you click on the new category. You can have any number of categories but a contact can only be in a single category at a time. And you can move and copy them between categories. If you have duplicate contacts, these can be placed into another category or deleted.
    Last edited by carwiz; 21 Jul 2014 at 23:37. Reason: correction
      My Computer


  6. Posts : 6,458
    x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
       #6

    Wembley said:
    Hi A Guy, I have done all the things suggested, and all that has happened is that I now have dozens of duplications in my contact list and no sign of the distribution list I was trying to import Do you have any suggestions as to how I can sort this mess out??!!!
    Hi,

    I'm not sure how you got dozens of duplicates, but that's really not important.

    I've made this mess a few times myself and sorting it out isn't fun or easy. The best I can offer is for you to export all of your contacts to a .csv file

    Make sure you select all fields for the export by ticking all of the checkboxes.

    Then open the .csv file in Excel or another spreadsheet application.

    Select the entire spreadsheet (Ctrl+A) and sort by the column with last name (surname), and the column with first name (givenname).

    Hopefully the entries truly are duplicates and you can go row-by-row removing the extraneous contacts.

    Now you have a base and a backup of your contacts.

    Make sure you have all of your contacts in that .csv file..... because you're about to delete all of the contacts in WLM

    Launch WLM
    open contacts
    select all (Ctrl+A)
    press the delete key

    Click import on the contacts home ribbon and specify the .csv file you sorted out.

    There are some limitations to any eMail client import/export. Mailing lists for instance - I don't recall any client importing or exporting lists. Mostly because the list relies on the contact being defined in a database and the list is juts a pointer to the real entry.

    Ask any questions before hitting the delete key. Had you asked about distribution lists, the answer you received would have been different. C'est la vie!

    Bill
    .
      My Computer


  7. Posts : 4
    Windows 7 64 bit
    Thread Starter
       #7

    Hi Slartybart, thanks for your reply. I suppose it actually is a distribution list!! In fact I think I have now managed to get the contacts into my own contact list and now just have to deal with over 600 duplications!! I want to do as you suggest, but how do I make my contacts list into a .csv file?
      My Computer


  8. Posts : 6,458
    x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
       #8

    Open Windows Essentials (Live) Mail (WEM or WLM)
    Press the Contacts icon
    Select Export from the Home Ribbon
    Select Comma Separated Values (.CSV) as the export format
    Press the Browse button, and name the output file (Default folder is Documents)
    tick all of the fields to export
    Press the Finish button

    Open the .CSV file in your spreadsheet program to check that everything was exported correctly
    If it doesn't look like the fields are separate columns, you probably didn't have the correct delimiter specified when you opened the spreadsheet.
    Close it and open it again - make sure the comma delimiter is ticked (probably a good idea to have ONLY the comma delimiter ticked).
    You can export the contacts as many times as you need - I wish they had a check all on the fields to export, but alas...
    It's important at this point to be certain of the data, the next steps will remove the contacts from WLM

    Then the fun begins!

    Select the entire spreadsheet (Ctrl+A)
    Select sort from the data menu

    I changed my mind on the sort
    In one sort operation (three sort field column selections: sort on Email Address, Last Name, and First Name
    This will make it a little easier than sorting only by Last Name, First Name

    It's work, but after reviewing a few addresses, you see a pattern.
    Delete the rows with duplicate addresses, keeping one with a good address.

    When you're satisfied that you have cleaned up the contacts list,

    Save AS a new .CSV file. Keep the original file as your backup.

    Are you sure you have the original export file?
    Is your new contact list, sans duplicates, ready to ne imported?

    Launch WLM
    open contacts
    select all (Ctrl+A)
    press the delete key

    Click import on the contacts home ribbon and specify the .csv file you sorted out.

    There are some limitations to any eMail client import/export. Mailing lists for instance - I don't recall any client importing or exporting lists. Mostly because the list relies on the contact being defined in a database and the list is juts a pointer to the real entry.

    This is important because the Category lists (distribution lists) you made are gone or invalid. These will have to be created anew. Sorry about the bad news.

    Ask any questions before hitting the delete key.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 07:01.
Find Us