Simple clear advice in plain English

How do I export a contacts list from Windows Live Mail?

Create a useful printed backup of your address book contacts

340-ht-01
The CSV file can contain all the contact information you choose

I like to keep a printed backup of my contacts and have found that the best way to do this is to export the address book from Windows Live Mail to Open Office Calc, not least because the contacts aren’t exported in any useful order.

Click on Contacts in the left-hand column of Windows Live Mail. Click on Export in the Ribbon and on Comma separated values (.CSV).

For Windows Live Mail on Windows XP, press the Alt button, click on File, Export and Comma Separated Values (.CSV). Next, select a name and location using the Browse button and click on Next. Select the information to include and then click on Finish.

Open this file in Open Office Calc. Press Ctrl and A to select the whole workbook. Click on the Data menu and then Sort. Select the ‘Range contains column labels in the Options tab. Select the columns you want to sort by in the Sort Criteria tab and click on OK. The list is now sorted and ready to print.
Steel, Computeractive forum

Reader Comments

   

Add your comment

Please keep comments constructive and free from abuse of any kind and swearing. If you wish to link to a product or service online, please do so in such a way that makes it clear that it is not spam. If you are connected to any such product you should make that clear.

We may use your comments in the magazine. We may edit your comments for clarity or to remove unacceptable material. We will attribute your comments but not share your email address.

We request your email address and record your Internet Address (IP address) in order to block spam from our site. We will never share this information without your permission.

All comments are reviewed by the Computeractive Team before being published. Please bear with the slight delay this causes, you don't need to post more than once.

Click here to read our Privacy Policy

Click here to read our site Terms & Conditions

Related articles

q-a-logo

Can I import contacts on from a CSV file?

Transfer your information to a Windows Mobile phone

sychronising-contacts-illustration

Use Windows Live Mail to synchronise contacts

Keep calendars and contacts synchronised across PCs with Windows Live Mail

large

Use free software to synchronise phone contacts

Zyb is a great free way to back up and synchronise mobile phones

Content Recommendation

Question & Answer

Q.Why is Windows Backup skipping files?

> Read the answer

Q.Why do my scanned documents display gibberish?

> Read the answer

Q.How can I convert MTS files to edit in Windows Movie...

> Read the answer

Best deals on the web

img

Samsung NP350E7C-A04UK

£349.99- Buy it now

img

Toshiba Satellite C850D-11Q (PSCC2E-00R00JEN)

£279.97- Buy it now

img

ASUS Eee PC X101CH-BLK043S

£239.99- Buy it now

Updating your subscription status Loading

Most popular articles

No matching document

Poll

Do you have Windows 8?

Jargon Buster

Computing terms explained in plain English

VGA

Video Graphics Array. Standard socket for connecting a monitor to a computer.

Great shopping deals from Computeractive

Information currently unavailable