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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
Outlook 2003 not importing from Excel
I have tried a couple of times now to import contacts (28 of them) from a
spreadsheet into Office Outlook 2003 SP3 (running under Vista Home Premium). The Import dialogue progresses perfectly well, and enables me to select spreadsheet (though not the page within it!) and the contacts folder to use. It then lets me map the fields as I wish, and goes through a progress window where it claims to be importing the entries. Afterwards I find that none of the entries in the spreadsheet has been imported. None at all. They aren't in any other contacts list either. Is this a known problem? Is there a solution? TIA Richard |
Ads |
#2
|
|||
|
|||
Outlook 2003 not importing from Excel
Try this - create a couple of contacts in Outlook and export to Excel.
Examine the output and your Excel spreadsheet and massage yours accordingly. I bet you don't have your field names correct. -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. After furious head scratching, Richard asked: | I have tried a couple of times now to import contacts (28 of them) | from a spreadsheet into Office Outlook 2003 SP3 (running under Vista | Home Premium). | | The Import dialogue progresses perfectly well, and enables me to | select spreadsheet (though not the page within it!) and the contacts | folder to use. It then lets me map the fields as I wish, and goes | through a progress window where it claims to be importing the entries. | | Afterwards I find that none of the entries in the spreadsheet has been | imported. None at all. They aren't in any other contacts list | either. | | Is this a known problem? | | Is there a solution? | | TIA | Richard |
#3
|
|||
|
|||
Outlook 2003 not importing from Excel
Most likely cause of problem is the "named range" for the data you want to
import is either not specified in the workbook or is incorrect (other than that - importing from Excel in Outlook works exactly as advertised). Alternate solution - save the worksheet you want to import as a CSV file and import that file into Outlook instead, mapping the fields as required. This approach saves a lot people a great deal of aggravation since named ranges do not come into play in this scenario. Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Richard" (none) wrote in message ... I have tried a couple of times now to import contacts (28 of them) from a spreadsheet into Office Outlook 2003 SP3 (running under Vista Home Premium). The Import dialogue progresses perfectly well, and enables me to select spreadsheet (though not the page within it!) and the contacts folder to use. It then lets me map the fields as I wish, and goes through a progress window where it claims to be importing the entries. Afterwards I find that none of the entries in the spreadsheet has been imported. None at all. They aren't in any other contacts list either. Is this a known problem? Is there a solution? TIA Richard |
#4
|
|||
|
|||
Outlook 2003 not importing from Excel
Karl,
I have the same problem importing contacts. However, excel will not let me save the file as a csv. What is the next option? thanks "Karl Timmermans" wrote in message ... Most likely cause of problem is the "named range" for the data you want to import is either not specified in the workbook or is incorrect (other than that - importing from Excel in Outlook works exactly as advertised). Alternate solution - save the worksheet you want to import as a CSV file and import that file into Outlook instead, mapping the fields as required. This approach saves a lot people a great deal of aggravation since named ranges do not come into play in this scenario. Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Richard" (none) wrote in message ... I have tried a couple of times now to import contacts (28 of them) from a spreadsheet into Office Outlook 2003 SP3 (running under Vista Home Premium). The Import dialogue progresses perfectly well, and enables me to select spreadsheet (though not the page within it!) and the contacts folder to use. It then lets me map the fields as I wish, and goes through a progress window where it claims to be importing the entries. Afterwards I find that none of the entries in the spreadsheet has been imported. None at all. They aren't in any other contacts list either. Is this a known problem? Is there a solution? TIA Richard |
#5
|
|||
|
|||
Outlook 2003 not importing from Excel
If Excel won't let you save worksheet as a CSV file coupled with the
original issue then would suggest creating a new workbook and re-construct your worksheet. If you can't save it as a CSV file - then you have some more serious issues with your overall configuration. Alternatively, it is very possible that you have a corrupted Excel workbook so I wouldn't discount that as a possibility. We've had a few workbooks sent to us that were corrupt which only really became evident when we went beyond just opening the workbook. Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "John" wrote in message ... Karl, I have the same problem importing contacts. However, excel will not let me save the file as a csv. What is the next option? thanks "Karl Timmermans" wrote in message ... Most likely cause of problem is the "named range" for the data you want to import is either not specified in the workbook or is incorrect (other than that - importing from Excel in Outlook works exactly as advertised). Alternate solution - save the worksheet you want to import as a CSV file and import that file into Outlook instead, mapping the fields as required. This approach saves a lot people a great deal of aggravation since named ranges do not come into play in this scenario. Karl __________________________________________________ _ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter "Power contact importers/exporters for MS Outlook '2000/2007" http://www.contactgenie.com "Richard" (none) wrote in message ... I have tried a couple of times now to import contacts (28 of them) from a spreadsheet into Office Outlook 2003 SP3 (running under Vista Home Premium). The Import dialogue progresses perfectly well, and enables me to select spreadsheet (though not the page within it!) and the contacts folder to use. It then lets me map the fields as I wish, and goes through a progress window where it claims to be importing the entries. Afterwards I find that none of the entries in the spreadsheet has been imported. None at all. They aren't in any other contacts list either. Is this a known problem? Is there a solution? TIA Richard |
#6
|
|||
|
|||
Outlook 2003 not importing from Excel
On May 26, 7:26*am, "Richard" (none) wrote:
I have tried a couple of times now to import contacts (28 of them) from a spreadsheet into Office Outlook 2003 SP3 (running under Vista Home Premium). The Import dialogue progresses perfectly well, and enables me to select spreadsheet (though not the page within it!) and the contacts folder to use. It then lets me map the fields as I wish, and goes through a progress window where it claims to be importing the entries. Afterwards I find that none of the entries in the spreadsheet has been imported. *None at all. *They aren't in any other contacts list either.. Is this a known problem? Is there a solution? TIA Richard Hi, If necessary, I think you can try a utility called Advanced Excel Repair to repair your Excel xls file. It works rather well for my corrupt Excel xls files. Its web address is http://www.datanumen.com/aer/ Alan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing Contacts from Word via Excel, Outlook 2003 | Gordon | Outlook - General Queries | 1 | January 19th 07 12:49 PM |
error importing excel calendar to outlook 2003 | SANMAN07 | Outlook - Calandaring | 1 | July 21st 06 01:08 PM |
Importing Outlook Alias into an Excel 2003 macro | fidgitthedigit | Outlook - General Queries | 2 | May 30th 06 02:11 PM |
Outlook 2003: While importing contacts from Excel 2003, ISAM error | Juzar | Outlook - Using Contacts | 1 | April 10th 06 10:20 PM |
Outlook 2003 when importing from Excel | Renae | Outlook - Using Contacts | 4 | March 4th 06 04:41 AM |