error importing excel calendar to outlook 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SANMAN07 - 20 Jul 2006 23:15 GMT

i created an excel file with"start date" and "subject". I put in the calendar
info. I tried importing it to outlook 2003, and i get an error. it tells me
the file has no named ranges. It then says to use the excel file to name the
range of data i want to import. But i don't know where i have to do that or
how. any help please and thank you

Reply to this Message

Sue Mosher [MVP-Outlook] - 21 Jul 2006 13:08 GMT

Open the Excel file.
Select all the data you want to import.
Choose Insert | Name | Define.
Give the range a name.
Save the file.
Import again.

Signature

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

>i created an excel file with"start date" and "subject". I put in the calendar
> info. I tried importing it to outlook 2003, and i get an error. it tells me
> the file has no named ranges. It then says to use the excel file to name the
> range of data i want to import. But i don't know where i have to do that or
> how. any help please and thank you

Reply to this Message

Rate this thread: