Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)
-   -   Can I create a contact list by importing data from excel? (http://www.outlookbanter.com/outlook-using-contacts/18054-can-i-create-contact-list.html)

Steve Peek June 16th 06 05:08 PM

Can I create a contact list by importing data from excel?
 
Is it possible to to take data from an excel, text for word file and import
it to create a Contact list in OutlooK?

Sue Mosher [MVP-Outlook] June 16th 06 05:13 PM

Can I create a contact list by importing data from excel?
 
Have you tried Outlook's File | Import and Export wizard?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Steve Peek" wrote in message ...
Is it possible to to take data from an excel, text for word file and import
it to create a Contact list in OutlooK?


Brian Tillman June 16th 06 10:10 PM

Can I create a contact list by importing data from excel?
 
Steve Peek wrote:

Is it possible to to take data from an excel, text for word file and
import it to create a Contact list in OutlooK?


What do you mean by "Contact list"?
--
Brian Tillman

SAlders June 18th 06 12:42 AM

Can I create a contact list by importing data from excel?
 
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


"Steve Peek" wrote:

Is it possible to to take data from an excel, text for word file and import
it to create a Contact list in OutlooK?



All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright 2004-2006 OutlookBanter.com