![]() |
import 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!! |
import one item lost
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. -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... 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!! |
import one item lost
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 -actionnew 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??!! "Russ Valentine [MVP-Outlook]" wrote: 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. -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... 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!! |
import one item lost
Did you create a named range in Excel before you did the import?
How did you map fields? -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... 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 -actionnew 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??!! "Russ Valentine [MVP-Outlook]" wrote: 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. -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... 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!! |
import one item lost
(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 "Russ Valentine [MVP-Outlook]" wrote: Did you create a named range in Excel before you did the import? How did you map fields? -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... 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 -actionnew 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??!! "Russ Valentine [MVP-Outlook]" wrote: 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. -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... 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!! |
import one item lost
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 he http://support.microsoft.com/default...Product=ol2002 -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... (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 "Russ Valentine [MVP-Outlook]" wrote: Did you create a named range in Excel before you did the import? How did you map fields? -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... 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 -actionnew 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??!! "Russ Valentine [MVP-Outlook]" wrote: 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. -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... 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 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!! |
import one item lost
I thought I had the mapping correct! Had not clicked on the + !!
Thanks for the help! "Russ Valentine [MVP-Outlook]" wrote: 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 he http://support.microsoft.com/default...Product=ol2002 -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... (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 "Russ Valentine [MVP-Outlook]" wrote: Did you create a named range in Excel before you did the import? How did you map fields? -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... 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 -actionnew 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??!! "Russ Valentine [MVP-Outlook]" wrote: 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. -- Russ Valentine [MVP-Outlook] "Steelcity Gal" wrote in message ... 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 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!! |
All times are GMT +1. The time now is 06:48 PM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com