A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Tags: , , , ,

Contact Import omits Email Address





 
 
Thread Tools Display Modes
  #1  
Old March 1st 08, 10:45 AM posted to microsoft.public.outlook.contacts
Mark[_6_]
external usenet poster
 
Posts: 2
Default Contact Import omits Email Address

I have successfully exported a list of contacts from Outlook 2007 into Excel
2003, when importing them back into Outlook 2007 on a different machine the
email address details are not being populated.

Can anyone suggest a resolution?

Ads
  #2  
Old March 1st 08, 01:20 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 8,884
Default Contact Import omits Email Address

You would never transfer Outlook data in this fashion. There is no need to
export or import, especially thorough a non-native file type.
Copy your Outlook data file and open it in the other installation.
--
Russ Valentine
[MVP-Outlook]
"Mark" wrote in message
...
I have successfully exported a list of contacts from Outlook 2007 into
Excel 2003, when importing them back into Outlook 2007 on a different
machine the email address details are not being populated.

Can anyone suggest a resolution?


  #3  
Old March 1st 08, 01:58 PM posted to microsoft.public.outlook.contacts
Mark[_6_]
external usenet poster
 
Posts: 2
Default Contact Import omits Email Address

Thanks Russ will remember for the future - is the method that you're
suggesting done using PSTs?

Unfortunately, I needed to transfer the contacts as I was moving companies..
I don't have access to the original PC and now have the contacts in an Excel
file. It imported every other field without an issue but is omitting the
email address fields for some reason.

Any ideas to save me inputting them all by hand?


"Russ Valentine [MVP-Outlook]" wrote in message
news
You would never transfer Outlook data in this fashion. There is no need to
export or import, especially thorough a non-native file type.
Copy your Outlook data file and open it in the other installation.
--
Russ Valentine
[MVP-Outlook]
"Mark" wrote in message
...
I have successfully exported a list of contacts from Outlook 2007 into
Excel 2003, when importing them back into Outlook 2007 on a different
machine the email address details are not being populated.

Can anyone suggest a resolution?



  #4  
Old March 1st 08, 03:07 PM posted to microsoft.public.outlook.contacts
Russ Valentine [MVP-Outlook]
external usenet poster
 
Posts: 8,884
Default Contact Import omits Email Address

Yes. PST is Outlook's native format for a data file.
You should still be able to import from Excel. List the steps you used. Make
sure you use a named range in Excel and have mapped your fields correctly.
The email addresses should populate correctly. The only thing that often
goes wrong is that the addresses will not resolve, so will not appear in the
address book view until you open and save each Contact Record. A third party
utility may be able to help you with Outlook's shortcomings:
http://www.contactgenie.com/

--
Russ Valentine
[MVP-Outlook]
"Mark" wrote in message
...
Thanks Russ will remember for the future - is the method that you're
suggesting done using PSTs?

Unfortunately, I needed to transfer the contacts as I was moving
companies.. I don't have access to the original PC and now have the
contacts in an Excel file. It imported every other field without an issue
but is omitting the email address fields for some reason.

Any ideas to save me inputting them all by hand?


"Russ Valentine [MVP-Outlook]" wrote in message
news
You would never transfer Outlook data in this fashion. There is no need
to export or import, especially thorough a non-native file type.
Copy your Outlook data file and open it in the other installation.
--
Russ Valentine
[MVP-Outlook]
"Mark" wrote in message
...
I have successfully exported a list of contacts from Outlook 2007 into
Excel 2003, when importing them back into Outlook 2007 on a different
machine the email address details are not being populated.

Can anyone suggest a resolution?




  #5  
Old March 1st 08, 10:03 PM posted to microsoft.public.outlook.contacts
Karl Timmermans
external usenet poster
 
Posts: 485
Default Contact Import omits Email Address

When mapping the email address - what email fields are you using for the map
on the Outlook side of things?

More to the point, the email address field in your Excel worksheet which
should contain only should be specifically mapped to one of
the following on the Outlook side "Email Address", "Email 2 Address", or
"Email 3 Address". If you map to either Email, Email 1, or Email 3 - you may
end up with an invalid value in the "Email Type" field causing the problem
you describe. Under normal circumstances, there is no need to map the Email
Type field when importing.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com


"Mark" wrote in message
...
Thanks Russ will remember for the future - is the method that you're
suggesting done using PSTs?

Unfortunately, I needed to transfer the contacts as I was moving
companies.. I don't have access to the original PC and now have the
contacts in an Excel file. It imported every other field without an issue
but is omitting the email address fields for some reason.

Any ideas to save me inputting them all by hand?


"Russ Valentine [MVP-Outlook]" wrote in message
news
You would never transfer Outlook data in this fashion. There is no need
to export or import, especially thorough a non-native file type.
Copy your Outlook data file and open it in the other installation.
--
Russ Valentine
[MVP-Outlook]
"Mark" wrote in message
...
I have successfully exported a list of contacts from Outlook 2007 into
Excel 2003, when importing them back into Outlook 2007 on a different
machine the email address details are not being populated.

Can anyone suggest a resolution?





  #6  
Old March 7th 08, 03:42 AM posted to microsoft.public.outlook.contacts
Sarah0824
external usenet poster
 
Posts: 1
Default Contact Import omits Email Address

I just wanted to thank you for this post, Karl. It solved the problem I was
having with importing from Excel. You saved me a TON of time and allowed me
to keep the hair on my head!!

"Karl Timmermans" wrote:

When mapping the email address - what email fields are you using for the map
on the Outlook side of things?

More to the point, the email address field in your Excel worksheet which
should contain only should be specifically mapped to one of
the following on the Outlook side "Email Address", "Email 2 Address", or
"Email 3 Address". If you map to either Email, Email 1, or Email 3 - you may
end up with an invalid value in the "Email Type" field causing the problem
you describe. Under normal circumstances, there is no need to map the Email
Type field when importing.

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com


"Mark" wrote in message
...
Thanks Russ will remember for the future - is the method that you're
suggesting done using PSTs?

Unfortunately, I needed to transfer the contacts as I was moving
companies.. I don't have access to the original PC and now have the
contacts in an Excel file. It imported every other field without an issue
but is omitting the email address fields for some reason.

Any ideas to save me inputting them all by hand?


"Russ Valentine [MVP-Outlook]" wrote in message
news
You would never transfer Outlook data in this fashion. There is no need
to export or import, especially thorough a non-native file type.
Copy your Outlook data file and open it in the other installation.
--
Russ Valentine
[MVP-Outlook]
"Mark" wrote in message
...
I have successfully exported a list of contacts from Outlook 2007 into
Excel 2003, when importing them back into Outlook 2007 on a different
machine the email address details are not being populated.

Can anyone suggest a resolution?





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
import email address from inbox messages? Jeremy Schubert Outlook - General Queries 5 December 4th 07 02:31 AM
Calendar printing omits full length of multiple day appoitments. Jeff Outlook - Calandaring 3 September 29th 07 08:32 AM
Can't get SMTP address of contact that shares email address of an Exchange user Jeff Outlook and VBA 13 August 9th 07 02:04 AM
Email address book back up and import Bugzie Outlook - Using Contacts 1 September 24th 06 07:03 PM
Set which local email account can send mail to contacts in address book. (associating an email address with a contact) Scott Streit Outlook - General Queries 3 January 27th 06 03:57 PM


All times are GMT +1. The time now is 08:31 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2008 Outlook Banter, part of the NewsgroupBanter project.
The comments are property of their posters.
Bad Credit Mortgages - Fujitsu coupons - Advertising - Credit Card - Remortgages