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 | Display Modes |
#1
|
|||
|
|||
All of my information isn't coming over when I save as a CSV file.
Please help!!! ASAP!!! I am having the most awful time trying to get all my
saved information over to my Outlook 2003 contacts. Even when I named the ranges and saved as a CSV file none of the changes came over to Outlook. I have a bunch of blank contacts in Outlook for some reason and it says that there are 99,283 items in my contacts when I only have like 900 contacts. I just want my changes to come over and find out how to get rid of all those blank entries. This is for my boss and she needs it like yesterday. I would hate to have and type all that information over again. Can some one please provide me with this information? |
#3
|
|||
|
|||
Most common cause for this is that the rows (or columns depending on issue
reported) have been "blanked out" versus being "deleted". Visibly there is no distinction between the two but makes a big difference in what rows/columns Excel thinks exists. If you're rows are at the beginning of your worksheet and you're "named range" is set correctly to cover only those 900+ contacts you shouldn't have an issue. If you save the worksheet to CSV - it will export all rows it thinks are valid (blank or otherwise - if you notice, there is no "named range" option to select when you save your worksheet to CSV). All you need to do is open your CSV file in any text editor and you'll see how many rows Excel has saved in that format - these will show up as a string of commas for each "empty row". Solution - just "delete" the empty rows or ensure your Excel "named range" is correctly set to import directly from Excel into Outlook. Karl -- __________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com "Ms. Lost" Ms. wrote in message ... Please help!!! ASAP!!! I am having the most awful time trying to get all my saved information over to my Outlook 2003 contacts. Even when I named the ranges and saved as a CSV file none of the changes came over to Outlook. I have a bunch of blank contacts in Outlook for some reason and it says that there are 99,283 items in my contacts when I only have like 900 contacts. I just want my changes to come over and find out how to get rid of all those blank entries. This is for my boss and she needs it like yesterday. I would hate to have and type all that information over again. Can some one please provide me with this information? |
#4
|
|||
|
|||
See all of this is very confusing to me, I tried both ways and it is still
not bringing all of my information over. I'm not sure about the mapping option. Here are the steps I took: 1. Exported my list from the Outlook contacts and saved as a CSV file. 2. Updated my changes in Excel 3. First tried to import the changes back into the contacts 4. Got a message saying that I need to name the ranges I wanted sent over. I selected the first row and named it, then I save another version and saved only the rows that had chages. (Maybe I'm going wrong here with the way I am selecting the ranges. 5. Completed the export and it seemed to come over fine, However none of the changes I made came over. 6. Saved the file as a CSV file and still no changes came over. In laimens terms can you break down where I'm making my mistake(s)? "Sue Mosher [MVP-Outlook]" wrote: ..csv files don't have named ranges. What happens when you import from your Excel worksheet that does have a named range? Have you checked the field mapping? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Ms. Lost" Ms. wrote in message ... Please help!!! ASAP!!! I am having the most awful time trying to get all my saved information over to my Outlook 2003 contacts. Even when I named the ranges and saved as a CSV file none of the changes came over to Outlook. I have a bunch of blank contacts in Outlook for some reason and it says that there are 99,283 items in my contacts when I only have like 900 contacts. I just want my changes to come over and find out how to get rid of all those blank entries. This is for my boss and she needs it like yesterday. I would hate to have and type all that information over again. Can some one please provide me with this information? |
#5
|
|||
|
|||
Repeating: .csv files don't have named ranges. It still sounds like you
created a named range, then imported the .csv file. You need to use one method or the other: 1) Make all the changes you want in Excel, then save as a .csv file and import into Outlook. 2) Make all the changes you want in Excel, then select then entire set of data you want to import, including column headings and choose Insert | Name | Define to create a named range. Use File | Save As to save as an Excel ..xls file, then import into Outlook. In both cases, you should check the field mapping in the Import and Export Wizard to make sure it's what you want. Also, in both cases, you can feel free to delete rows that weren't changed. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Dominique" wrote in message ... See all of this is very confusing to me, I tried both ways and it is still not bringing all of my information over. I'm not sure about the mapping option. Here are the steps I took: 1. Exported my list from the Outlook contacts and saved as a CSV file. 2. Updated my changes in Excel 3. First tried to import the changes back into the contacts 4. Got a message saying that I need to name the ranges I wanted sent over. I selected the first row and named it, then I save another version and saved only the rows that had chages. (Maybe I'm going wrong here with the way I am selecting the ranges. 5. Completed the export and it seemed to come over fine, However none of the changes I made came over. 6. Saved the file as a CSV file and still no changes came over. In laimens terms can you break down where I'm making my mistake(s)? "Sue Mosher [MVP-Outlook]" wrote: ..csv files don't have named ranges. What happens when you import from your Excel worksheet that does have a named range? Have you checked the field mapping? "Ms. Lost" Ms. wrote in message ... Please help!!! ASAP!!! I am having the most awful time trying to get all my saved information over to my Outlook 2003 contacts. Even when I named the ranges and saved as a CSV file none of the changes came over to Outlook. I have a bunch of blank contacts in Outlook for some reason and it says that there are 99,283 items in my contacts when I only have like 900 contacts. I just want my changes to come over and find out how to get rid of all those blank entries. This is for my boss and she needs it like yesterday. I would hate to have and type all that information over again. Can some one please provide me with this information? |
#6
|
|||
|
|||
Thank you so much. You were right, I did name the ranges before saving it to
a CSV file. I went back and selected only the cells I wanted in the Excel format then I imported the file over. Another question if I'm not bothering you: How come only the zip codes with the 4 digit code afterwards came over to my contacts? The other zip codes didn't come over at all. Can you help with this? "Sue Mosher [MVP-Outlook]" wrote: Repeating: .csv files don't have named ranges. It still sounds like you created a named range, then imported the .csv file. You need to use one method or the other: 1) Make all the changes you want in Excel, then save as a .csv file and import into Outlook. 2) Make all the changes you want in Excel, then select then entire set of data you want to import, including column headings and choose Insert | Name | Define to create a named range. Use File | Save As to save as an Excel ..xls file, then import into Outlook. In both cases, you should check the field mapping in the Import and Export Wizard to make sure it's what you want. Also, in both cases, you can feel free to delete rows that weren't changed. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Dominique" wrote in message ... See all of this is very confusing to me, I tried both ways and it is still not bringing all of my information over. I'm not sure about the mapping option. Here are the steps I took: 1. Exported my list from the Outlook contacts and saved as a CSV file. 2. Updated my changes in Excel 3. First tried to import the changes back into the contacts 4. Got a message saying that I need to name the ranges I wanted sent over. I selected the first row and named it, then I save another version and saved only the rows that had chages. (Maybe I'm going wrong here with the way I am selecting the ranges. 5. Completed the export and it seemed to come over fine, However none of the changes I made came over. 6. Saved the file as a CSV file and still no changes came over. In laimens terms can you break down where I'm making my mistake(s)? "Sue Mosher [MVP-Outlook]" wrote: ..csv files don't have named ranges. What happens when you import from your Excel worksheet that does have a named range? Have you checked the field mapping? "Ms. Lost" Ms. wrote in message ... Please help!!! ASAP!!! I am having the most awful time trying to get all my saved information over to my Outlook 2003 contacts. Even when I named the ranges and saved as a CSV file none of the changes came over to Outlook. I have a bunch of blank contacts in Outlook for some reason and it says that there are 99,283 items in my contacts when I only have like 900 contacts. I just want my changes to come over and find out how to get rid of all those blank entries. This is for my boss and she needs it like yesterday. I would hate to have and type all that information over again. Can some one please provide me with this information? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Get Latest Entry with Query | James Stephens | Running & Setting Up Queries | 3 | February 25th, 2005 06:59 PM |
Randomizing table information | Wayne Morgan | General Discussion | 3 | February 22nd, 2005 01:16 AM |
Free Busy Information | Peter Lau | Calendar | 1 | September 28th, 2004 02:57 PM |
How create sam information in several word documents | Mike | General Discussion | 1 | September 3rd, 2004 05:45 PM |
Contact information not being displayed | JEV | Contacts | 1 | June 14th, 2004 10:24 PM |