Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you import data into specific cells of an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
trying to import excel database into outlook need to name ranges | Excel Worksheet Functions | |||
How do I enter Outlook contact data into excel? | Excel Discussion (Misc queries) | |||
How do I import data from 1 workbook excel sheet into another? | New Users to Excel | |||
how do i import data from excel, sort it then that information is. | Excel Discussion (Misc queries) |