 |
 | 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 / September 2006Importing excell to outlook but having problems
Hi, I am wondering if anyone on this list can help me with this problem: I am trying to import an excell file to outlook contacts but it is giving me an error that the file has no named ranges. I need to name the range os data .. does any one know what that means? Thanks Dani In Excel, select all the data, then choose Insert | Name | Define  SignatureSue 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 > Hi, > [quoted text clipped - 6 lines] > Thanks > Dani Sue, This is helping me too. However, now that I am able to get the information to cross over to contacts. It will not pull over my first contact. I mapped out the crossover. I hope you can give me more answers...Thanks a bunch. Laura > In Excel, select all the data, then choose Insert | Name | Define > [quoted text clipped - 8 lines] > > Thanks > > Dani Did you save the file after adding the named range? Does the range include all the data you want to import and column headings that tell you what data is in each column? SignatureSue 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 > Sue, This is helping me too. However, now that I am able to get the > information to cross over to contacts. It will not pull over my first > contact. I mapped out the crossover. I hope you can give me more > answers...Thanks a bunch. Laura > >> In Excel, select all the data, then choose Insert | Name | Define >> >> > Hi, [quoted text clipped - 7 lines] >> > Thanks >> > Dani I cannot remember if I saved it again and no I did not include the column headdings the first time. The second time I tried it I highlighted the headdings as well. > Did you save the file after adding the named range? Does the range include all the data you want to import and column headings that tell you what data is in each column? > [quoted text clipped - 16 lines] > >> > Thanks > >> > Dani You have to save the file if you want Outlook to be able to use your changes. SignatureSue 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 >I cannot remember if I saved it again and no I did not include the column > headdings the first time. The second time I tried it I highlighted the > headdings as well. > >> Did you save the file after adding the named range? Does the range include all the data you want to import and column headings that tell you what data is in each column? >> >> > Sue, This is helping me too. However, now that I am able to get the [quoted text clipped - 15 lines] >> >> > Thanks >> >> > Dani |
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
|
©2008 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.