 |
 | 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 2005I am having trouble importing an excel file into contacts in outlo
I cannot get all the information in an Excel file to import into the contacts in Outlook, expecially the e-mails which have been created as hyperlinks in the excel file. I am getting only the first row of information to import. Did you use Insert | Name | Create to create a named range in the worksheet covering all the data you want to import?  SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx >I cannot get all the information in an Excel file to import into the >contacts > in Outlook, expecially the e-mails which have been created as hyperlinks > in > the excel file. I am getting only the first row of information to import. I did...however I am thinking that the format of those cells in Excel has something to do with it only importing the first letter of the email address. All other information is importing correctly > Did you use Insert | Name | Create to create a named range in the worksheet > covering all the data you want to import? [quoted text clipped - 4 lines] > > in > > the excel file. I am getting only the first row of information to import. And how are they formatted in Excel? SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx >I did...however I am thinking that the format of those cells in Excel has > something to do with it only importing the first letter of the email [quoted text clipped - 4 lines] >> worksheet >> covering all the data you want to import? >> >I cannot get all the information in an Excel file to import into the >> >contacts [quoted text clipped - 3 lines] >> > the excel file. I am getting only the first row of information to >> > import. Originally as e-mail hyperlinks. Then I changed them to "General"....still didn't work. > And how are they formatted in Excel? > [quoted text clipped - 14 lines] > >> > the excel file. I am getting only the first row of information to > >> > import. I sure can't duplicate the problem here, even with an address set up as a hyperlink. How did you map the fields? SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Originally as e-mail hyperlinks. Then I changed them to > "General"....still > didn't work. > >> And how are they formatted in Excel? >> >I did...however I am thinking that the format of those cells in Excel >> >has [quoted text clipped - 13 lines] >> >> > the excel file. I am getting only the first row of information to >> >> > import. Did you try assigning a name to the whole area of cells containing the informations? Hope i helps |
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.