![]() |
| 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. |
|
|||||||
| Tags: created, import, info, outlook, worksheet |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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 | |
|
|
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 |