Donate SIGN UP

Excel help

Avatar Image
richardf | 15:27 Tue 22nd May 2007 | Technology
2 Answers
Hi you lovely answerbank people. I'm trying to make a mailing list for the youth project i help to run and i'm having problems with excel....

I have a mailing list already in express and i want to transfer all the email address from that mailing list onto an excel spreadsheet. However when i do a copy and paste all the contacts go into one cell and not differtn cells like i want. Can you help? thanks in advance
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by richardf. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
In OE, open Addresses.
Select the contacts list that you want to use
Click File/Export/Other Address Book
Choose Text File(Comma Separated Values)
Save it to somewhere appropriate.

Open the folder where you save the file, and double-click the file. It should automatically open in Excel.


Go into Excel, click Data then Get External Data then Import Text File.
You may have to copy the text out of Express to Notepad first.

1 to 2 of 2rss feed

Do you know the answer?

Excel help

Answer Question >>