#1
|
|||
|
|||
Importing Excell date into Outlook trouble
I have an Excel spreadsheet of my contacts, and when in Outlook, I am trying to import them into contacts there. I get the following:
file has no named ranges. in Excel, name the range of date you want to import. I am using Office 2007 and Vista Home Premium and would appreciate any help here. Thanks |
#2
|
|||
|
|||
Yes, Outlook requires the range to be named. To do so:
a) Select the range, including all the column labels and all the data b) Go to the Formulas tab and click ‘Define Name’ c) Verify the ‘Refers to” box lists the correct range d) Type the desired name… “data”, for example, in the Name textbox. No space characters are allowed. Then click OK to close the ‘New Name’ dialog box Outlook 2007 also required that the Excel file be a version 97-2003, so you will need to save it as one. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing a .ics file to Outlook | Sparky65 | Outlook | 0 | 04-07-2010 04:27 AM |
Trouble importing from web page into Excel 2007 | JHCOLVI | Excel | 0 | 02-25-2010 12:18 PM |
Having trouble with keywords in Outlook Rule | mfarring | Outlook | 0 | 02-03-2010 08:17 AM |
new appointment date always reverts back to today's date | msills | Outlook | 0 | 08-24-2007 08:57 AM |
Imported message date change to today's date | promark | Outlook | 1 | 12-23-2005 07:21 AM |