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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
import Excel to Outlook, each field importing as separate contact
I am trying to import contact data from Excel to Outlook. Records are
arranged in Rows, with column headings for Name, Email etc, but when it imports it is importing each individual data field as a separate contact. Help! |
Ads |
#2
|
|||
|
|||
import Excel to Outlook, each field importing as separate contact
Did you create a single named range for the rows and columns you want to import? DId you double-check the field mapping?
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "ozbrandi" wrote in message ... I am trying to import contact data from Excel to Outlook. Records are arranged in Rows, with column headings for Name, Email etc, but when it imports it is importing each individual data field as a separate contact. Help! |
#3
|
|||
|
|||
import Excel to Outlook, each field importing as separate cont
I am having the same problem. I have gone through the instructions more than
5X and still the same thing happens. I have verified the name range, made sure all of the mapping is correct and the data still comes out as individual contacts. Any additional help would be greatly appreciated. "Sue Mosher [MVP-Outlook]" wrote: Did you create a single named range for the rows and columns you want to import? DId you double-check the field mapping? -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "ozbrandi" wrote in message ... I am trying to import contact data from Excel to Outlook. Records are arranged in Rows, with column headings for Name, Email etc, but when it imports it is importing each individual data field as a separate contact. Help! |
#4
|
|||
|
|||
import Excel to Outlook, each field importing as separate cont
Do you get a different result if you save the data to be imported as a ..csv file and import that file instead of the spreadsheet?
-- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Nancy" wrote in message ... I am having the same problem. I have gone through the instructions more than 5X and still the same thing happens. I have verified the name range, made sure all of the mapping is correct and the data still comes out as individual contacts. Any additional help would be greatly appreciated. "Sue Mosher [MVP-Outlook]" wrote: Did you create a single named range for the rows and columns you want to import? DId you double-check the field mapping? "ozbrandi" wrote in message ... I am trying to import contact data from Excel to Outlook. Records are arranged in Rows, with column headings for Name, Email etc, but when it imports it is importing each individual data field as a separate contact. Help! |
#5
|
|||
|
|||
import Excel to Outlook, each field importing as separate cont
That worked!!!!
Thank you so much!!!! "Sue Mosher [MVP-Outlook]" wrote: Do you get a different result if you save the data to be imported as a ..csv file and import that file instead of the spreadsheet? -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Nancy" wrote in message ... I am having the same problem. I have gone through the instructions more than 5X and still the same thing happens. I have verified the name range, made sure all of the mapping is correct and the data still comes out as individual contacts. Any additional help would be greatly appreciated. "Sue Mosher [MVP-Outlook]" wrote: Did you create a single named range for the rows and columns you want to import? DId you double-check the field mapping? "ozbrandi" wrote in message ... I am trying to import contact data from Excel to Outlook. Records are arranged in Rows, with column headings for Name, Email etc, but when it imports it is importing each individual data field as a separate contact. Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
importing from Excel - getting one field per record | KevinHenck | Outlook - Using Contacts | 1 | February 11th 06 07:03 PM |
Import from Excel User specified Contact Information | ut | Outlook - General Queries | 2 | February 2nd 06 03:38 PM |
Import Outlook Contact Postal Code from Excel | Vaughn | Outlook - Using Contacts | 1 | January 28th 06 12:14 PM |
Import contact list from excel | Sue Mosher [MVP-Outlook] | Outlook - Using Contacts | 0 | January 20th 06 05:45 PM |
Import Excel to Outlook creates separate records for each fiel | rachel | Outlook - Using Contacts | 1 | January 13th 06 09:30 PM |