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

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.

"Karen" wrote:

> 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

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
"Heno" <(E-Mail Removed)> wrote in message
news:10D247C4-066A-4BFA-9310-(E-Mail Removed)...
> 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.
>
> "Karen" wrote:
>
>> 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

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

"Judy Gleeson (MVP Outlook)" wrote:

> 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
> "Heno" <(E-Mail Removed)> wrote in message
> news:10D247C4-066A-4BFA-9310-(E-Mail Removed)...
> > 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.
> >
> > "Karen" wrote:
> >
> >> 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
>
>
>

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

"Heno" wrote:

> 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.
>
> "Karen" wrote:
>
> > 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