All of my information isn't coming over when I save as a CSV file.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ms. Lost - 09 Mar 2005 16:47 GMT

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?

Reply to this Message

Sue Mosher [MVP-Outlook] - 09 Mar 2005 17:27 GMT

.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?

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> Please help!!! ASAP!!! I am having the most awful time trying to get all
> my
[quoted text clipped - 11 lines]
>
> Can some one please provide me with this information?

Reply to this Message

Dominique - 09 Mar 2005 18:07 GMT

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)?

> ..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
[quoted text clipped - 15 lines]
> >
> > Can some one please provide me with this information?

Reply to this Message

Sue Mosher [MVP-Outlook] - 09 Mar 2005 18:16 GMT

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.

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> 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
[quoted text clipped - 45 lines]
>> >
>> > Can some one please provide me with this information?

Reply to this Message

Dominique - 09 Mar 2005 19:49 GMT

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?

> 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
[quoted text clipped - 61 lines]
> >> >
> >> > Can some one please provide me with this information?

Reply to this Message

Karl Timmermans - 09 Mar 2005 17:35 GMT

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

Signature

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com

> Please help!!! ASAP!!! I am having the most awful time trying to get all
> my
[quoted text clipped - 11 lines]
>
> Can some one please provide me with this information?

Reply to this Message

Rate this thread: