Home |
Search |
Today's Posts |
#1
|
|||
|
|||
trying to import excel database into outlook need to name ranges
I am trying to import my excel database that has names, addresses and phone
numbers into my contacts for Microsoft Outlook. It won't allow me to and is asking me to "name the ranges" in Excel before I can continue. Well...My ranges are named and it still won't let me. Help! |
#2
|
|||
|
|||
Open your workbook. Select all the data. Hit Insert--Name--Define and call
it mycontacts. Save, close. Now try it. If it still doesn't work... do you have blank rows or columns? Not allowed.... ******************* ~Anne Troy www.OfficeArticles.com "Shawnee Wright" <Shawnee wrote in message ... I am trying to import my excel database that has names, addresses and phone numbers into my contacts for Microsoft Outlook. It won't allow me to and is asking me to "name the ranges" in Excel before I can continue. Well...My ranges are named and it still won't let me. Help! |
#3
|
|||
|
|||
Shawnee
This is how I do it. The basics........Your layout may differ. Instructions here are for Name and Email address only, but adjust to suit for more columns. First have the names and email addresses in Excel in two columns. I set up also a third column with the names duplicated so when you Import to Outlook you have a name for the Contact and a Display Name instead of the email address in the To: box. FileSave AsFile Type CSV(comma delimited)(*.csv) Click "Yes" when you get the messages about losing formats and "are you sure"? Close the file. Now open Outlook and FileImport/ExportImport from another fileComma Separated Values(Windows)NextFile to Import(you can browse to your saved *.csv file). Next you will be asked where to import them to. I bring mine to "Contacts". Follow the instructions and you will get a Map. Drag your names and addresses to the appropriate spots on the Map 1. Name of Contact 2. Email address1 3. Display Name(if you have one by making the duplicate column mentioned earlier). If not, the email address wil be displayed in the To: box. Continue with the OK's until Outlook pulls all from the *.csv file(should take only a few seconds). Now they are in the Contacts folder, you can group them as you wish. Gord Dibben Excel MVP On Tue, 19 Jul 2005 16:36:01 -0700, "Shawnee Wright" <Shawnee wrote: I am trying to import my excel database that has names, addresses and phone numbers into my contacts for Microsoft Outlook. It won't allow me to and is asking me to "name the ranges" in Excel before I can continue. Well...My ranges are named and it still won't let me. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use Excel to post data to an external database? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Import data from files with different names to EXCEL D'base. | Excel Discussion (Misc queries) | |||
On an import to excel a two digit date still is not right after c. | Excel Discussion (Misc queries) | |||
Update a Database Using Excel | Excel Worksheet Functions |