Export email addresses from Word to Windows Live Mail

[Wembley]

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.

 

[A Guy]

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.



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

 

[Wembley]

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??!!!

 

[A Guy]

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

 

[carwiz]

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.

 

[Slartybart]

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
.

 

[Wembley]

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?

 

[Slartybart]

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.