Can I create a contact list by importing data from excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to to take data from an excel, text for word file and import
it to create a Contact list in OutlooK?
 
Have you tried Outlook's File | Import and Export wizard?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Steve Peek said:
Is it possible to to take data from an excel, text for word file and
import it to create a Contact list in OutlooK?
Click to expand...

What do you mean by "Contact list"?
 
Funny you asked that question. I just finished Importing an Excel (2003)
file over to Outlook (2003) myself.
The first thing you have to do is name the range of cells that you are going
to Export. Once finish with that task you then save the file and close out of
it.
Now open up Outlook, click the file menu & scroll down to where it says,
‘Import and Export… and click on that, which will now open the Import &
Export Wizard menu. Now scroll down to where it says “Import from another
program or file†and highlight that choice. Select the ‘NEXT’ button at the
bottom of the dialog box and you will go to your next dialog box which is
where you will scroll down and select your type of program that you want to
import, being Microsoft Excel. Once you select Excel, in that menu another
menu will pop up asking you to locate the excel file you want to import.
Hopefully you named & ranged the correct cells, way back in that Excel
worksheet you started out in. If not, you’ll have to go back to the
spreadsheet and make your corrections, otherwise you’ll get an error message
every time you try to import & export that file.
GOOD LUCK
 
Back
Top