Email address from Outlook Contacts

  • Thread starter Thread starter Kevin Lucas
  • Start date Start date
K

Kevin Lucas

I have a worksheet that contains the names of contacts. Most are identical
to contacts in my Outlook XP standard Contacts folder. I would like to be
able to enter a new contact in Excel and have the email address from Outlook
email address 1 appear in another Excel column.

As I already have many contacts in Excel I'd also like to be able to go
through all the existing contacts and have their email addresses appear.

Is it possible to do this and if so how please?

Many thanks for any insights you have.
Kevin Lucas
 
Hi Kevin,
The usual thing to do would be to Export your Outlook address
book or your Outlook Express addressbook as a .CSV file
and bring that into Excel by opening it and then probably copy
and paste that into your workbook that your are using..

You could use VLOOKUP to obtain the email address from the
sheet you bring into Excel. Certainly not as automated as you
asked for. http://www.mvps.org/dmcritchie/excel/vlookup.htm

One thing to watch out for is that the exported file does not have
an ending comma, so you might want to make sure that you
generate a comma at the end if you intend to import the file
back into Outlook. (I use Outlook Express, not Outlook).
 
Back
Top