![]() |
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
|
|||
|
|||
![]()
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 |
Ads |
#2
|
|||
|
|||
![]()
In Excel, select all the data, then choose Insert | Name | Define
-- 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 wrote in message ups.com... 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 |
#3
|
|||
|
|||
![]()
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 "Sue Mosher [MVP-Outlook]" wrote: In Excel, select all the data, then choose Insert | Name | Define -- 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 wrote in message ups.com... 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 |
#4
|
|||
|
|||
![]()
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 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 "greece329" wrote in message ... 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 "Sue Mosher [MVP-Outlook]" wrote: In Excel, select all the data, then choose Insert | Name | Define wrote in message ups.com... 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 |
#5
|
|||
|
|||
![]()
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. "Sue Mosher [MVP-Outlook]" wrote: 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 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 "greece329" wrote in message ... 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 "Sue Mosher [MVP-Outlook]" wrote: In Excel, select all the data, then choose Insert | Name | Define wrote in message ups.com... 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 |
#6
|
|||
|
|||
![]()
You have to save the file if you want Outlook to be able to use your changes.
-- 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 "greece329" wrote in message ... 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. "Sue Mosher [MVP-Outlook]" wrote: 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? "greece329" wrote in message ... 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 "Sue Mosher [MVP-Outlook]" wrote: In Excel, select all the data, then choose Insert | Name | Define wrote in message ups.com... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problems importing data from Outlook Express | Manhoco | Outlook - Installation | 1 | July 18th 06 09:59 PM |
PlanPlus v 3 (and Outlook 2003 SP2) - install problems, uninstall problems, bugs? | kkernspa | Add-ins for Outlook | 0 | April 9th 06 03:07 AM |
still problems - importing to outlook | Steelcity Gal | Outlook - Using Contacts | 8 | February 2nd 06 06:46 PM |
Outlook Problems | John Passafiume | Outlook - General Queries | 15 | January 21st 06 07:15 PM |
Address book moving/importing problems | DrB | Outlook Express | 12 | January 14th 06 03:27 PM |