![]() |
| 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. |
|
|||||||
| Tags: address, contact, email, import, omits |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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 | |
|
|
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 |