Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Export email addresses from Word to Windows Live Mail

14 Jul 2014   #1
Wembley

Windows 7 64 bit
 
 
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 System SpecsSystem Spec
.
14 Jul 2014   #2
A Guy

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium x64 SP1
 
 

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 System SpecsSystem Spec
21 Jul 2014   #3
Wembley

Windows 7 64 bit
 
 

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 System SpecsSystem Spec
.

21 Jul 2014   #4
A Guy

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium x64 SP1
 
 

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 System SpecsSystem Spec
21 Jul 2014   #5
carwiz

Windows 7 Pro-x64
 
 

Quote   Quote: Originally Posted by Wembley View Post
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.
My System SpecsSystem Spec
22 Jul 2014   #6
Slartybart

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

Quote   Quote: Originally Posted by Wembley View Post
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 System SpecsSystem Spec
23 Jul 2014   #7
Wembley

Windows 7 64 bit
 
 

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 System SpecsSystem Spec
23 Jul 2014   #8
Slartybart

x64 (6.3.9600) Win8.1 Pro & soon dual boot x64 (6.1.7601) Win7_SP1 HomePrem
 
 

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 System SpecsSystem Spec
Reply

 Export email addresses from Word to Windows Live Mail




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Windows Live Mail - Export and Import Email Messages
How to Export and Import Email Messages in Windows Live Mail This will show you how to export (backup) and import (restore) all or select message folders that contain your email messages, or only single email messages in Windows Live Mail. To Export or Import All Email Messages in One or...
Tutorials
Windows Live Mail - Export and Import Email Accounts
How to Export and Import Email Accounts in Windows Live Mail This tutorial will show you how to export (backup) and import (restore) your email accounts in Windows Live Mail. Export or Backup Email Accounts in Windows Live Mail 1. Open Windows Live Mail.
Tutorials
Send To Email not working for WORD and Live Mail
Hello everyone, I'm REALLY frustrated :mad: so bear with me. I have Office 2007 Home & Student Edition. I use Windows Live Mail for my email client. I installed the office product, and created a new Word Document. I click on the Office Button on top, select SEND TO EMAIL.. expecting Windows...
Microsoft Office
Windows Live mail 2011 can the email addresses from autocomplete be ex
Where are the autocomplete email addresses stored and can they be exported to an Outlook nk2 file?
Browsers & Mail
Importing email addresses from Outlook Express to Windows 7 Live mail
I have bought a new computer with Windows 7 preinstalled. Before setting it up I backed up all my outstanding emails (204 .dbx files) and email addresses (one .wab file size 176kb) from my old computer on to a memory stick. I now want to import them into Windows Live Mail. I have gone through the...
Browsers & Mail
send email in live mail direct from word 2007 doc
I am trying to send email direct or as attachment direct from Windows Live Mail direct from a Word 2007 home and student document. I ám using Windows 7 home premium 64 bit with Office 2007 home and student Word I am not techy - does the word MAPI (not IMAP) mean anything in this...
Browsers & Mail


Our Sites

Site Links

About Us

Find 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 22:03.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App