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

[oaksie1]

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?

 

[Sue Mosher [MVP-Outlook]]

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

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[oaksie1]

How do I do that?

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

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Sue Mosher [MVP-Outlook]]

Insert | Range | Define.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[mollyjean]

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

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers