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 - General Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Tags: , , , ,

i can't get outlook to import info from the worksheet it created





 
 
Thread Tools Display Modes
  #1  
Old June 8th 06, 02:31 PM posted to microsoft.public.outlook
oaksie1
external usenet poster
 
Posts: 2
Default i can't get outlook to import info from the worksheet it created

I created an Excel worksheet from a contact list in outlook by exporting it.
When I add contacts to the same Excel worksheet, outlook won't import the new
data. What am I doing wrong?
Ads
  #2  
Old June 8th 06, 02:45 PM posted to microsoft.public.outlook
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default i can't get outlook to import info from the worksheet it created

DId you expand the named range on the worksheet to cover the new data?

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

"oaksie1" wrote in message ...
I created an Excel worksheet from a contact list in outlook by exporting it.
When I add contacts to the same Excel worksheet, outlook won't import the new
data. What am I doing wrong?

  #3  
Old June 8th 06, 03:45 PM posted to microsoft.public.outlook
oaksie1
external usenet poster
 
Posts: 2
Default i can't get outlook to import info from the worksheet it creat

How do I do that?

"Sue Mosher [MVP-Outlook]" wrote:

DId you expand the named range on the worksheet to cover the new data?

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

"oaksie1" wrote in message ...
I created an Excel worksheet from a contact list in outlook by exporting it.
When I add contacts to the same Excel worksheet, outlook won't import the new
data. What am I doing wrong?


  #4  
Old June 8th 06, 04:10 PM posted to microsoft.public.outlook
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default i can't get outlook to import info from the worksheet it creat

Insert | Range | 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

"oaksie1" wrote in message ...
How do I do that?

"Sue Mosher [MVP-Outlook]" wrote:

DId you expand the named range on the worksheet to cover the new data?



"oaksie1" wrote in message ...
I created an Excel worksheet from a contact list in outlook by exporting it.
When I add contacts to the same Excel worksheet, outlook won't import the new
data. What am I doing wrong?


  #5  
Old July 20th 06, 06:11 PM posted to microsoft.public.outlook
mollyjean
external usenet poster
 
Posts: 2
Default i can't get outlook to import info from the worksheet it creat

I have a similar problem but don't have "Range" as an option. Would I do
Insert | Name | Define and then what with all the items in the workbook?

"Sue Mosher [MVP-Outlook]" wrote:

Insert | Range | 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

"oaksie1" wrote in message ...
How do I do that?

"Sue Mosher [MVP-Outlook]" wrote:

DId you expand the named range on the worksheet to cover the new data?



"oaksie1" wrote in message ...
I created an Excel worksheet from a contact list in outlook by exporting it.
When I add contacts to the same Excel worksheet, outlook won't import the new
data. What am I doing wrong?


  #6  
Old July 20th 06, 06:13 PM posted to microsoft.public.outlook
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default i can't get outlook to import info from the worksheet it creat

Insert | Range | Define is the command to create a named range. The range needs to cover all the data you want to import. Save the file after you create the range.

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

"mollyjean" wrote in message ...
I have a similar problem but don't have "Range" as an option. Would I do
Insert | Name | Define and then what with all the items in the workbook?

"Sue Mosher [MVP-Outlook]" wrote:

Insert | Range | 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

"oaksie1" wrote in message ...
How do I do that?

"Sue Mosher [MVP-Outlook]" wrote:

DId you expand the named range on the worksheet to cover the new data?



"oaksie1" wrote in message ...
I created an Excel worksheet from a contact list in outlook by exporting it.
When I add contacts to the same Excel worksheet, outlook won't import the new
data. What am I doing wrong?


 




Thread Tools
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
Hyperlinking from Outlook 2003 to an excel Worksheet fidgitthedigit Outlook - General Queries 2 May 5th 06 05:32 PM
How to import data in self created forms? Oliver Burkhardt Outlook - Using Contacts 1 April 4th 06 03:00 PM
Need a utility to import mail to Outlook via print dialog... or some other way to import proprietary messages into Outlook. Alan Outlook - General Queries 9 April 3rd 06 06:14 PM
Can I get statistical data from the bookings created in Outlook? Sally-AnneF Outlook - Calandaring 0 February 7th 06 02:35 PM
Prevent Reminder bein created by outlook Wolf Add-ins for Outlook 1 February 6th 06 10:10 PM


All times are GMT +1. The time now is 10:02 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2008 Outlook Banter, part of the NewsgroupBanter project.
The comments are property of their posters.
Credit Cards - Mobile Phones - Loan - Debt - Online Loans