Importing from Excel - EM Addresses missing .

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NFJim - 07 Apr 2007 23:20 GMT

Found all my answers about importing from Excel here but still have these two
odd problems. In my email addresses, the . has been replaced with a # when
mapping the fields. So an em address looks like this j#smith@abc#com. I
didn't try to import not knowing what would happen. The other is that my zip
code field which consists of 5 digits such as 123435 shows up as F6 or
something like that.

Reply to this Message

NFJim - 09 Apr 2007 14:52 GMT

OK...took a chance and tried to import three contacts just to see what would
happen. The information imorted except for the very first contact on my Excel
spread sheet. No matter what I do or how many contacts I try to import the
very first one never gets imported. Even if I select just the first contact
when I define my range, it does the importing or so it says, but when I go to
my contact list in Outlook it is not there. Any ideas?

> Found all my answers about importing from Excel here but still have these two
> odd problems. In my email addresses, the . has been replaced with a # when
> mapping the fields. So an em address looks like this j#smith@abc#com. I
> didn't try to import not knowing what would happen. The other is that my zip
> code field which consists of 5 digits such as 123435 shows up as F6 or
> something like that.

Reply to this Message

NFJim - 09 Apr 2007 16:10 GMT

Thanks for all the help....I figured it out.

> OK...took a chance and tried to import three contacts just to see what would
> happen. The information imorted except for the very first contact on my Excel
[quoted text clipped - 9 lines]
> > code field which consists of 5 digits such as 123435 shows up as F6 or
> > something like that.

Reply to this Message