 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / February 2006import one item lost
I finally am able to import contacts, make catagories etc!! However, when I tried to import my contacts list ~ one of the headers - email - did not import. I made sure it was labeled/named correctly ~ mapped correctly, etc., also tried to import just that header ~ All that shows up in the email slot is the first letter of the persons name. It worked on the other computer when I was learning! What do I need to do? I am running XP small business ~ outlook 2002 Thanks!! Importing is flawed in Outlook. You should use it only if you need to import from a different data source. Are you? Never use importing to transfer data from one version of Outlook to another.  SignatureRuss Valentine [MVP-Outlook] >I finally am able to import contacts, make catagories etc!! However, when I > tried to import my contacts list ~ one of the headers - email - did not [quoted text clipped - 7 lines] > outlook 2002 > Thanks!! I imported from Excel ~ I did the import from the source workbook - it was missing the email address (just first letter showed) so then I tried just to import the email column from excel - didnt work - I then made a new spread sheet - renamed everything tried to import and the email addresses still came up with just the first character of the email (it was in the correct place at least!) So then I did a "copy/paste" while I was in the catagory view - but now when I try to send from the catagory (using -action>new message to contact) it says that "some of my contacts do not have email address and their name will be used. I put all the addresses in! The email address shows both in the catagory view and in the edit contact tab. So how do I fix??!! > Importing is flawed in Outlook. You should use it only if you need to import > from a different data source. Are you? [quoted text clipped - 10 lines] > > outlook 2002 > > Thanks!! Did you create a named range in Excel before you did the import? How did you map fields? SignatureRuss Valentine [MVP-Outlook] >I imported from Excel ~ I did the import from the source workbook - it was > missing the email address (just first letter showed) so then I tried just [quoted text clipped - 30 lines] >> > outlook 2002 >> > Thanks!! (in top left of excel) Named all "Columns" different name than header - Named range of information (a-g + 1 -155) then i did an "insert > name > define" Went into outlook - followed the wizard - picked the name of the range to import - it mapped itself so I viewed - all info correctly in right area. did import - email was the only header that did not completely import - just the first letter of the address. I also tried again and when I got to the mapping point I cleared the map and did a drag & drop to map - same results > Did you create a named range in Excel before you did the import? > How did you map fields? [quoted text clipped - 32 lines] > >> > outlook 2002 > >> > Thanks!! You need to examine the content of the email field in Excel to be sure it is in valid format and data type. You need to examine the filed mapping yourself and make sure it is mapping to the correct field, as described here: http://support.microsoft.com/default.aspx?scid=kb;en-us;319904&Product=ol2002 SignatureRuss Valentine [MVP-Outlook] > (in top left of excel) Named all "Columns" different name than header - > Named [quoted text clipped - 54 lines] >> >> > outlook 2002 >> >> > Thanks!! I thought I had the mapping correct! Had not clicked on the + !! Thanks for the help! > You need to examine the content of the email field in Excel to be sure it is > in valid format and data type. You need to examine the filed mapping [quoted text clipped - 59 lines] > >> >> > outlook 2002 > >> >> > Thanks!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.