A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Importing excell to outlook but having problems



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old July 18th 06, 11:10 PM posted to microsoft.public.outlook.contacts
[email protected]
external usenet poster
 
Posts: 1
Default Importing 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

Ads
  #2  
Old July 19th 06, 01:26 AM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Importing excell to outlook but having problems

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  
Old September 15th 06, 11:44 PM posted to microsoft.public.outlook.contacts
greece329
external usenet poster
 
Posts: 6
Default Importing excell to outlook but having problems

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  
Old September 16th 06, 12:14 AM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Importing excell to outlook but having problems

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  
Old September 16th 06, 01:56 AM posted to microsoft.public.outlook.contacts
greece329
external usenet poster
 
Posts: 6
Default Importing excell to outlook but having problems

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  
Old September 16th 06, 03:59 AM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Importing excell to outlook but having problems

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
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


All times are GMT +1. The time now is 08:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.