How to import Outlook Contact data into Excel
 

I have MS Outlook 2002 SP£ and Excel 2002 SP3. I am trying to import contact
data from Outlook into Excel where I have created a template for sending out
my invoices. Rather than type in data I thought that there must be a way to
import the data from my contacts folder in Outlook. Ihave tried via MS Word
'Merge' programme but nothing but rubbish comes out as I cannot enter fields
- Word converts my Excel file into its format and scrambles all!
Had assumed it would be straightforward - Any sensible and successful ideas
anyone?

I have Outlook and Excel 2003 so I don't know how different this may be
in 2002 but try this:

In Outlook, click on FileImport and Export Export to a file. You can
then browse in the Wizard window for the Contacts folder to select it.
(If you don't want all your contacts, then before you start this select
the ones you want and copy them to a new folder.)

The wizard will let you then select what type of file to Export to and
one of those choices is an Excel file.

It worked well for me. Good Luck.


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=476194