Hello, thanks for helping me out.
This storey has a good ending, but I thought I might post it for anyone
else that might have this problem. Sorry for its length.
I believe the addresses are constructed properly. As far as their
validation…I am not sure what you mean by this. If you are asking
whether they are actual addresses on the internet, the answer is yes.
In fact 1 of them is mine. However I have discovered a term referring
to whether an email address is resolved, unfortunately I am not sure
how to verify this. If this refers to whether or not the email
addresses are underlined and active (clickable) the addresses I have
are not. However I am not sure this would be my problem. As a test,
in excel, I activated a couple of the addresses (email #1, made them
clickable), and the results were no different.
I have noticed that it appears as though any contact I have with two or
three e-mail addresses, the import wizard has correctly brings in the
second email information - Email 2, as well as the third, but it is
ignoring the first. This is a problem because most of my contacts only
have the one e-mail address. In my personal information I have 3
emails, the first one has been ignored but the other 2 have been
successfully imported. Structurally, in excel, I see no difference
between the addresses that are successfully dealt with and those that
are ignored.
To further my investigation, after importing the excel data, I turned
around and exported the contacts list back to excel. I then compared
the two sheets. Again, I see no difference in the two sheets, except
for the fact that now… on the “exported from outlook to excel” sheet I
have no e-mail #1. (email #2 and #3 are shown). And again,
structurally, in excel, I see no difference between the addresses that
are successfully dealt with and those that are ignored, even across the
imported list vs the exported list.
Taking your advise, I first deleted my contacts in outlook and then
saved my excel file as a csv. file. I then imported the csv file to
outlook using the wizard. This generated less success. Now I have no
email addresses in outlook. All other data appears to be intact and
appears to have be imported correctly. Just no e-mail #1.
To further my investigation, after importing the csv data, I turned
around and exported the contacts list back to csv. I then compared the
two csv files. Again, I see no difference in the two sheets, except for
the fact that now… on the “exported from outlook to csv” sheet I have no
emails at all. The file I imported looks the same as the one I exported
in all respects except now outlook has not recognized any emails.
One thing to note, when I go to save my excel file as a csv. , a
message is brought up indicating that my file “may contain features
that are not compatible will csv format”. I choose to keep the work
book in the csv format.
I see no difference in the format of the 2nd and 3rd e-mail addresses
that seem to be successfully imported from excel to outlook, and the
1st emails that are ignored. The excel formula bar shows …
‘
[email protected] vs ‘
[email protected] . I see no extra
spaces after the ‘ that precedes the address.
One last thing that I observed, and I find this extremely strange. As
you use the import wizard, you follow theses steps… “ACTION TO PREFORM:
import from another program or file”; “TYPE of IMPORT: Microsoft
excel”; “FILE TO IMPORT(with duplicates options): import excel.xls
(replace duplicates)”; “SELECT DESTINATION FOLDER: Contacts”; “THE
FOLLOWING ACTIONS WILL BE PREFORMED: choose ‘import “contacts” into
folder: Contacts’… In this window there is a button to “Map Custom
Fields”. I have never looked at this much because when I was updating
my original contacts, I simply exported them to the excel file so I
could complete the upgrade, and to ensure the proper headings would be
used for the mapping. However, if you enter the “Map Custom Fields”
section, you are presented with a left side (excel) “value” that
represents your fields, and a right side (outlook) “field” which
represents the fields that outlook will be using. There is also a
“Mapped from” section that ensures the bridge between the two (your
excel value and the outlook field) is complete. I have expanded all the
Outlook fields out” and believe that they correspond or are mapped
correctly with my values. In my case the “outlook mapped from” and the
“excel values” are the same. And now for the strange part…at the bottom
of this screen there is a “Next” button. This button appears to let you
cycle through your records to ensure the actual excel values match up in
the correct fields in outlook. In your case…excel First: Karl would
appear as First: Karl in outlook. When I view the records for the
emails #1 …“EmailAddress” “EmailType” and “EmailDisplayName” the
“EmailAddress” does not show any value, however the second aspect to
e-mail #1 “EmailType” displays SMPT as it should, as does
“EmailDisplayName” “Joe Smoe”
It simply does not recognize that there is data in the excel sheet.
Soooooooooo. It thought, why not go back and see if it recognises the
values in a csv file. I started the wizard again, imported my csv
file, checked the mapping and to my surprise, a few fields, including
ALL my email fields #1, #2 and #3. The WERE NOT. mapped. Making a few
associations, and checking the record preview, I began to see light at
the end of the tunnel.
Completing the wizard, I believe I have now successfully imported my
contacts list using excel to save the file as a csv, but the big hiccup
was to ensure that the mapping was correct. I will need to verify the
data in outlook, but as it stands right now, I believe the problem of
the missing e-mail addresses have been solved. Thanks greatly to you!
Any idea why the outlook will not import that data from excel? I find
it very strange, that it (excel or outlook) would simply not recognize
that data when mapped correctly.
Thanks again for your help.
