Copy E-mail Addresses to Excel Spreadsheet

[Guest]

I need to make a list of many of my employees e-mail addresses and copy each
one to an Excel spreadsheet.
Instead of typing each e-mail address into Excel, I want to be able to copy
and paste all the addresses from Outlook to Excel. I thought I would be able
to open a new mail message, look up the employees name and copy and paste.
The problem is, it doesn't bring up the exact e-mail address. It brings up
the following format: Smith, Jonh. How can this be done.
I'm using Microsoft Office 2003
Thank you, Karen

 

[Guest]

Karen,

In Oulook use the menus, file....import/export....export to a file, then if
your email adress are in Contacts or Adress book, just follow the on-screen
prompts & all the details will be saved in an Excel file in My Documents,
with the email bit you need coming into about Column BH. You then cut & paste
to a more suiable location.

 

[Judy Gleeson \(MVP Outlook\)]

what are you trying to achieve by putting them in excel? It may be possible
to do what you want in Outlook.


Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au
Canberra, Australia

Imagine if every Thursday your shoes exploded if you tied them the usual
way. This happens to us all the time with computers, and nobody thinks of
complaining.
Jef Raskin, interviewed in Doctor Dobb's Journal

 

[Guest]

I have an existing spreadsheet that I need to add the e-mail addresses to for
my boss. Thanks

 

[Guest]

Thanks for your help - What I did was, I created a distribution list and
copied the e-mail address from the contact list.
Thanks