|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: data, excell, import, name, outlook, range |
|
|
Thread Tools | Display Modes |
|
#1
May 7th 07, 02:52 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
HOw do I name a range of data in excell to import into outlook?
I am trying to import excell spread sheets with student lists into my contact
so I can have them in one location. I keep getting an error saying that I have not named a range of data and that I should do so in Excell 
|
| Ads |
|
#2
May 7th 07, 03:00 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
HOw do I name a range of data in excell to import into outlook?
Export a few contacts from Outlook to Excel and compare the heading row in each. Massage yours accordingly.
-- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, Mike Rovinsky asked: | I am trying to import excell spread sheets with student lists into my | contact so I can have them in one location. I keep getting an error | saying that I have not named a range of data and that I should do so | in Excell
|
|
#3
May 7th 07, 10:33 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
HOw do I name a range of data in excell to import into outlook?
The step you need is an Excel question - how do you name a Range. Help in
Excel on this is non existant - I have been there a lot when helping clients with this type of import. Here ya go: Highight the section of the Excel sheet you want to export. The in the little white window top left, write a name for that Range eg Contacts. Shut Excel. (must do this) Go to Outlook. Use File Import/Export and this time you won't have a problem as you know the range you want is "Contacts". It will now go to the next step where you match the data fields and then Import. I hope this helps you at least a little bit! Judy Gleeson MVP Outlook Outlook trainer and author of Productiv_IT with Outlook read my articles he www.judygleeson.com www.acorntraining.com.au Canberra, Australia "Wasted end-user time due to lack of training accounted for the biggest piece of the spoftware spending pie" -Gartner "Milly Staples [MVP - Outlook]" wrote in message ... Export a few contacts from Outlook to Excel and compare the heading row in each. Massage yours accordingly. -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, Mike Rovinsky asked: | I am trying to import excell spread sheets with student lists into my | contact so I can have them in one location. I keep getting an error | saying that I have not named a range of data and that I should do so | in Excell
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Import data from MS Access into Outlook | JRSNHECI | Outlook - Using Contacts | 0 | January 16th 07 05:43 PM |
| i want to import list contact from excell,but i can only import | thanhtam | Outlook - Using Contacts | 1 | October 9th 06 01:58 PM |
| How do I import data into Outlook Calendar? | AppArchDude | Outlook - Calandaring | 0 | September 27th 06 06:08 PM |
| import all outlook express 5 data from Mac to PC - How..?? | gitarrero | Outlook - General Queries | 1 | June 15th 06 07:19 PM |
| Can I import data from Excel into Outlook | Sheila | Outlook - Using Contacts | 3 | April 17th 06 09:57 PM |
Linear Mode
